I have a database with a table in it which links with a server to obatin property addresses.
This is done when a button clears certain fields in an existing table and the populates them again from an excel file in sited on the business server.
This works a treat but I then have other tables in the same database which use the same addresses, which are already populated with no automation.
I was wondering if when the table gets updated is there a way to do a look up with the other table and if any new addresses have appeared it automatically adds them to the other table?

Any help much appreciated