how to validate a text from another text

[alex_raju]

hi, sir




i have a text name [cust_no]
and also i have a text name [shipto]

how i can make valiadation that [cust_no] data only can be valid in [shipto] text field if enter any other value msg should show invalid number?


thanks in advance

alex

[TheShabz]

This is where the "relational" part of relational database comes in. If shipto is a foreign key to cust_no, then Access will do that automatically for you.