I have two tables which I have created a relationship from (payer_det and stud_details).
However, when I am in the Edit Relationship and trying to Enforce Referential intergrity the following error is prompted
"Data in the table 'payer_det' violates the referential intergrity rules"
What can i do to sort this out?
The numhus field is in both the stud_details and payer_det, and forms the relationship. Relationship should be one- to- many. Also note I set the numhus field as the Primary key on the stud_details.
Thanks
However, when I am in the Edit Relationship and trying to Enforce Referential intergrity the following error is prompted
"Data in the table 'payer_det' violates the referential intergrity rules"
What can i do to sort this out?
The numhus field is in both the stud_details and payer_det, and forms the relationship. Relationship should be one- to- many. Also note I set the numhus field as the Primary key on the stud_details.
Thanks