can I make a field data type a choice ("x" or "y") instead yes/no

[Jeff]

in Access 2003 I would like to enter a choice in a table data type so I can
have a two choice ("x" or "y") ro a multiple choice ("a" or "b" or "c"). How
can I do this?

 

[Allen Browne]

You need to create a related table, so you can have as many choices as
apply.

Take a look at this article:
http://allenbrowne.com/casu-23.html

It uses a sport example, where a student may be involved in several sports.

 

[Duane Hookom]

IMO, you can't and shouldn't do this in a table design. It is fairly easy to
implement with a combo box on a form which is where all user interaction
should occur.