Master Table

[KMan]

Hi. I'm trying to make one master table to use as a reference point to send update queries to update records and fields that are found in other related tables. My problem is that there might be two records that have the same account name, account number, or transaction ID due to the fact that since it's a real estate database some transactions have split ownership or a buy and sale of a property happen in the same transaction. Is there anyway to update with the query without having it stop at the first instance. Or are there other ways to go about updating in this manner?

[orange]

Research Normalization, and tables and relationships design.
Good luck.