A database with Linking Tables

[djclntn]

Simultaneously, I'm maintaining 2-seperate used car dealership dbs which contains a Customers & a Vehicles Table amongst a few other tables which isn't relevant. Now I've created this other dbs in which I want to track 1) all of the vehicles sold, the sale price & sale Date via Dealership . 2) Likewise, I also wish to create a Customers table combining all of the customers from both dealerships. So, as I said I have 2-customers Tables from 2-dealerships, how can I combinee them into 1-table or query? And the data in these tables will be updated because they're linked to their individual dealership dbs.

[June7]

Each db can have links set to the other's tables. However, 'combining' the customer tables and still have them editable is probably not possible. A UNION query will accomplish the 'combine' and the two tables will appear as one. However, a UNION query is not editable. You can search, sort, filter but cannot edit the records.