Information générale
Titre:
Making 2 separate tables look like one when searching
Does anyone know how to make a table in one Access database be linked to another table in a different database? Basically I have two databases with with tables in each and they both have the same structure, number of fields etc. They contain data that I want to keep separate however so I don't want to just append records from one table to the next. I know that if you create a link in a database all that does is make a 'shortcut' if you will to the table from that database. I want join properties that include all fields from both tables, not just where they are both equal or one has records that the other has. I essentially want to be able to search both databases and both tables and have it appear as one table to the end user but have the actual data separate. The main table is to be updatable by the user and the other table only updatable by myself. Can anyone help please?
Thank you!
Max
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement