can you find enteries in all of your databases

E

Emery

Hi,

I have a question about if I can find enteries in all of my databases
without having to go to each one to find.

I have four databases.
 
J

John Vinson

Hi,

I have a question about if I can find enteries in all of my databases
without having to go to each one to find.

I have four databases.
Click to expand...

If you had four filing cabinets, could you find a letter which might
be in any of them without opening all four? Of course not. Same thing!

You can't find data in a database without opening that database.

My question would be - why are you storing the "same" data in four
different places in the first place? Normally, in a relational
database, you would follow the "Grandmother's Pantry Principle": "a
place - ONE place! - for everything, everything in its place".

Are these four different .mdb files (containers for multiple tables,
forms, reports, etc.) or four different tables in a single .mdb file?
What's the context?

John W. Vinson[MVP]
 
B

Brook

Can you provide more information?

What are you looking for?

Do all the tables have the same fields?

Brook
 
E

Emery

The reason I ask:

I am doing serate tables and entering contact information in four of them.
Doing a mail out and I did not want to print the same address. I have been
entering contact's and entering them from folders. I been printing the mail
address on envelopes. That why I been serate them.

When I have all the contacts enter I will put them from the other tables
into one table.

The tables are in the same mdb file.
 
J

John Vinson

The reason I ask:

I am doing serate tables and entering contact information in four of them.
Click to expand...

Why?

In a properly normalized database, you will have ONE table for each
type of Entity. If you have a bunch of contacts, a better design would
be to have ONE Contacts table, linked to whatever other tables you
need.
Doing a mail out and I did not want to print the same address. I have been
entering contact's and entering them from folders. I been printing the mail
address on envelopes. That why I been serate them.
Click to expand...

You do not need separate TABLES to generate separate REPORTS
(printouts); you can base your reports on queries which select only
those addresses that you want to print out.
When I have all the contacts enter I will put them from the other tables
into one table.

The tables are in the same mdb file.
Click to expand...

For the time being, you may be able to use a UNION query to string the
four tables together into one recordset, which can be searched as if
it were one table. See the online help for UNION.

John W. Vinson[MVP]
 
Top