Input data validation

[Access User]

Hi all, I have an table with the record of customer's purchasing items and I
would like to check whether these items are correctly input. To do so, I need
to use another table (called the label-table) for validation. this
label-table captures all the possible values of the purchasing item.

Anyone can suggest the fast way to do that?

thanks!

 

[vanderghast]

You create a relation between the table having all the possible values, and
the 'detail tables', over their common field, and you enforce the relation.
It is then not possible to add a record, or to modify one, in the table of
details so that its (item) value is not in the table with all possible
(item) values. You must first add the item in table with all possible values
before adding a record with that value in the table of details.


Vanderghast, Access MVP