can a record automatically be entered into do a different table using a record from another?
Is there a way to have a record automatically entered into do a different table using the data entered into a new record on the first table?
i have 3 tables, one for one purpose and another for eitirely different purpose. I also have one that is all the records of both added into one to check for duplicates across both tables and such. What i would like to happen is when a new record is entered into one of the 2 tables it is automatically added into the big comparison table. is there a way to make that happen?
Side-Note: I have relationships between the single tables and the joint table.