I'm pretty sure that no triggers are involved, because the database was very
badly designed at first. I was the one who created the relationships to work
with queries. The problem I had was data entry, as the designer didn't
provide a simple location from which data can be entered. There were
unrelated data everywhere, because of the data entry problem. I had to use a
delete query to delete the unrelated data, and now relationships control how
data is entered... i mean unrelated data cannot be entered now.

Actually the db collects information about staff in two different tables -
StaffNames and StaffContacts. StaffNames have the primary key, StaffContacts
have the foreign key. Earlier there was no relationship between StaffNames
and StaffContacts. But now, I have created a one-to-one relationship.

Although I didn't solve the actual problem, I followed a recommendation of
microsoft which employs subforms in adp which made life a whole lot easier.

But I would really like to know if there is a solution to the actual
problem.

Shafiee.