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

Sorting Multiple Tables 1
List all tables, including document structure 0
Search in multiple databases/tables 4
Embedded Excel into Word with Tables 0
Auto Populate One Pages from spreadsheet 0
Embed the same Excel multiple times 0
Using multiple databases 3
Merging databases 2

Top