Search in multiple databases/tables

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
--
nancye

Hi Nancy,

Why do you have document data in three separate databases.? Perhaps you need
to revise the structure and put all the document data in one table.
Searching for a document number would then be very simple. To do this, you
may need a new document type table. If you respond back with the document
table structure in each database, I may be able to help you further.

Steve


"Nancy" wrote in message
...
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
--
nancye

Careful Nancy, Steve is a known for conning people into free help and then
charging them. There are far better qualified people here who will honour
the purpose of these newsgroups as a place for FREE help.

John...

"Mark" wrote in message
m...
Hi Nancy,

Why do you have document data in three separate databases.? Perhaps you
need to revise the structure and put all the document data in one table.
Searching for a document number would then be very simple. To do this, you
may need a new document type table. If you respond back with the document
table structure in each database, I may be able to help you further.

Steve

"Mark" schreef in bericht m...
Hi Nancy,

Why do you have document data in three separate databases.? Perhaps you need
to revise the structure and put all the document data in one table.
Searching for a document number would then be very simple. To do this, you
may need a new document type table. If you respond back with the document
table structure in each database, I may be able to help you further.

Steve


Please go get lost Steve...

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

To *anyone* here in this group:
Feel free to show the link
http://home.tiscali.nl/arracom/whoissteve.html
anytime this so-called Mark (=Steve Santus) advertises here.

Arno R

On Tue, 24 Jun 2008 00:18:39 +0200, "StopThisAdvertising"
StopThisAdvertising@Data**** wrote:


"Mark" schreef in bericht m...
Hi Nancy,

Why do you have document data in three separate databases.? Perhaps you need
to revise the structure and put all the document data in one table.
Searching for a document number would then be very simple. To do this, you
may need a new document type table. If you respond back with the document
table structure in each database, I may be able to help you further.

Steve


Please go get lost Steve...

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

In Steve's defense, he (uncharacteristically) didn't solicit for work in this
particular post, but rather gave some accurate advice. I know why you're
packing this sixgun, but maybe your hairtrigger is a bit too sensitive.
--

John W. Vinson [MVP]

On Mon, 23 Jun 2008 12:02:01 -0700, Nancy wrote:

I have three databases with the same structure, table and field names

Why? That's a very badly flawed design. You're storing data in tablenames or
(even worse) database names; you would be much better off with *one table*,
perhaps with another field indicating which collection of data this record is
from.

(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?

You could use a fourth database (a "frontend") with no tables, but just links
to these three, and a UNION query stitching them all together. Performance
will likely be abominably bad but it *could* be done.

--

John W. Vinson [MVP]

"John W. Vinson" schreef in bericht ...

In Steve's defense, he (uncharacteristically) didn't solicit for work in this
particular post, but rather gave some accurate advice. I know why you're
packing this sixgun, but maybe your hairtrigger is a bit too sensitive.
--

John W. Vinson [MVP]

Hmmm... I am not sure about this hairtrigger...
You also know the silly game Steve plays don't you ??
It is of no use whatever to play *his* game anymore. We are way past that stage again.

He has been kicked out by earthlink so it seems.
He has been kicked out by supernews so it seems.
== You and others can really help kicking him out again by posting a message to
Pick any other of his recent advertising posts to grab the headers from.

Details about complaining: http://home.tiscali.nl/arracom/whoissteve.htm
(click section 'abuse-reporting')

Arno R