"validation between two different table text"

[alex_raju]

Hi,
Thanks in Advance....

I have created three table those are tbl_order, tbl_Supplier, tbl_shipper. these tables are connected with relationship,
tbl_supplier![Supplier_id] connected with tbl_order![Supplier_id], now, how i can make tbl_order![Supplier_id] should allow only exit ID in tbl_supplier![Supplier_id].


"validation between two different table text"



thank you,

alex

[Rawb]

In the Properties of the Relationship, there should be an option to "Enforce Referential Integrity"

Just check that option and you should be good.