RESOLVED: Relationship not working
Hi everyone. I have a database with 2 tables. I set a one-to-many relationship enforcing referential integrity, cascade updates.
Table A is the primary table, with "ReferralID" entered as a numbered field (the primary key).
Table B is populated via a subform, and "ReferralID" is not the primary key.
The way I have the relationship set up, it should automatically populate "referral ID" into table B when I create a table B record, and it should delete table B records when I delete a record from table A. Neither of these things happen. Any idea why?
Thanks.
Hi everyone. I have a database with 2 tables. I set a one-to-many relationship enforcing referential integrity, cascade updates.
Table A is the primary table, with "ReferralID" entered as a numbered field (the primary key).
Table B is populated via a subform, and "ReferralID" is not the primary key.
The way I have the relationship set up, it should automatically populate "referral ID" into table B when I create a table B record, and it should delete table B records when I delete a record from table A. Neither of these things happen. Any idea why?
Thanks.
Last edited: