Linked Tables

[jjarman]

Onto my next problem

I have one DB that is used for creating/storing customer ID's, and another DB that is used for creating/storing job information for customers.

I have linked the table from the customer DB to the job DB.

There is a table in the job database that holds customer name and ID, and some VBA that generates unique job codes (thanks ro everyone for that).
I would prefer to not try and mess with that coding to look at a linked table.... is it possible to have the data from the linked table automatically update into the existing table?
Not sure if this is the best way of doing it... just trying to avoid a lot of programming headaches.

 

[Beetle]

Do both of the customer tables (the linked and the local one) store the same data (CustomerID, CustomerName, etc.)?

If so, and if the linked table is the one with the most current information, then just use the linked table and delete the local table (after you make a backup of course). If the linked table uses the same name as the local table did, then you won't need to modify any code/queries etc.