Referential integrity enforcement via linked table
Posted on 2004-04-02
I am placing a relationship between "tblpaymentsreceived" and another table linked from another Access database that includes a joining reference field.
I reconciled both tables to ensure that data in the joining field was reflected in both tables and linked them.
A "One-to-Many" relationship was highlighted in the dialog box but I cannot check the "Enforce Referential Integrity" box. I have tried inputting an incorrect reference number in "tblpaymentsreceived" and no error message appeared.
Can I not enforce this referential integrity rule because of the linked table? If so, how can I discipline input (can I place a combo box in the "tblpaymentsreceived" field that only reflects reference numbers from the linked table)?