Validation rule

[stat123]

Hello,

I have an initial table (table1)containing 15,000 records. The user may enter records in table 2; I want to have a validation rule that checks if the record entered by the user is in table 1 (it has to be in there, to be able to proceed any further).

How can I do the above using a validation rule in the table design view?

Thank you for your help!

 

[vpelleri]

It seems to me that validation would be take care of if you establish a relationship between the two tables, where Table 1 represents the parent side of the relationship and table two represents the child.
If the field in table 1 is a key field, than you can establish such a relationship with table 2 by setting the Indexed property of the field in table 1 to allow no duplicates.
Is that what you are looking for?
Vince

 

[stat123]

Thank you for your response Vince.

This is one part of it: not to allow duplicates. But when the user enter a record number in table 2, I want to be able to check if the record exists in table 1; if not, an error message should pop up.

 

[randy700]

If you set your relationships, as suggested by vpelleri, an error message WILL be displayed upon any attempt to enter an unrelated record in table 2.

Randy

 

[PHV]

Anyway you may have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244