A
Allison
Access 2003, Win XP SP 3
I have a field in tblContacts called fldInactive. This is a Yes/No field.
I also have several other table relations where the unique fldContactID has
been associated with other related tables. One example is
"tblComboContactType", which contains a record that captures ContactID, and a
classification ID combination.
I want to delete all of the related associations for the ContactID when
someone indicates that the contact is now inactive.
I'm guessing this will have to look at every table except tblContacts, then
delete any record that contains the ContactID?
How would I do this?
Allison
I have a field in tblContacts called fldInactive. This is a Yes/No field.
I also have several other table relations where the unique fldContactID has
been associated with other related tables. One example is
"tblComboContactType", which contains a record that captures ContactID, and a
classification ID combination.
I want to delete all of the related associations for the ContactID when
someone indicates that the contact is now inactive.
I'm guessing this will have to look at every table except tblContacts, then
delete any record that contains the ContactID?
How would I do this?
Allison