can you find enteries in all of your databases

[Guest]

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.

 

[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.

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]

 

[Guest]

Can you provide more information?

What are you looking for?

Do all the tables have the same fields?

Brook

 

[Guest]

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.

 

[John Vinson]

The reason I ask:

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

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.

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.

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]