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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search in multiple databases/tables 3
Merging databases 2
Using multiple databases 3
split database question ... will have multiple back end databases 15
Merge Tables/Databases 2
Combining databases - Common People table, many other tables. 4
SQL upsize 2 databases 2
Automation of Linking Tables 2

Top