Limiting a value that can go into a field in one table can be done by
creating a lookup table with the 3 values and setting up referential
integrity. Use a combo box on a form to allow selection of one of the three
values into the field.

I have no idea what you mean by the remainder of your question.

--
Duane Hookom
MS Access MVP
--

"michelelenc" wrote in message
...
I am trying to design a database for an engineering group. I need to limit
or restrict the type of data that goes into a field to 3 choices. I would
also like to have the same number appear in another field in all records
and
if that isn't enough, I would like to be able to create a specific auto
numbering system to our unique specifications. Can you help me?
--
michelelenc