Hi,
I have a table of literature citations/references. This table is linked to four other tables by the primary/foreign key relationship. The relationship between the citation/reference table and each of the other tables is 1:1. If a user deletes a reference, is there an easy way for Access to simply null the primary key in the other tables if appropriate? I don't want to delete the linked records in the other tables, just null the primary key fields.
Any advice would be appreciated.
Thanks!
dftjsn
I have a table of literature citations/references. This table is linked to four other tables by the primary/foreign key relationship. The relationship between the citation/reference table and each of the other tables is 1:1. If a user deletes a reference, is there an easy way for Access to simply null the primary key in the other tables if appropriate? I don't want to delete the linked records in the other tables, just null the primary key fields.
Any advice would be appreciated.
Thanks!
dftjsn