Automatically update a table from another

[GraemeG]

Hello.

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

 

[Mr Smin]

I think you should aim to make one list of addresses the 'master' list and link both of your data tables to (in this case) your spreadsheet on the server.

Ideally you only want to store the text of the address in one place, with a primary key, and use that primary key as a foreign key anywhere else that the address is needed.