If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Search in multiple databases/tables
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 |
#3
|
|||
|
|||
Search in multiple databases/tables - Warning
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 |
#4
|
|||
|
|||
Search in multiple databases/tables
"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 |
#5
|
|||
|
|||
Search in multiple databases/tables
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] |
#6
|
|||
|
|||
Search in multiple databases/tables
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] |
#7
|
|||
|
|||
Search in multiple databases/tables
"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 |
Thread Tools | |
Display Modes | |
|
|