limiting data and validations

[michelelenc]

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?

 

[Duane Hookom]

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.