Search in Multiple Databases/ 3 or more tables

N

Nancy

I have three databases with the same structure, table and field names (data
tables are not linked, but can be), I need to be able to search all three
databases for document number. THe user would like a drop down of all
documents from all 3 databases (3 separate tables) Do I create a separate
database linking to all three? Can I get all documents from 3 tables into one
query or what is the best way to set this up?

Thank You

nancye
 
N

NetworkTrade

In a standard split database you could link your front end application to all
3 database's tables.
 
Top