Table relationship

[dr223]

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

 

[dr223]

Thanks well spotted!!!!