Queries

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I have several Access databases that I would like to be
able to query at the same time to look up a specific last
name. All my databases have Last Name as the first field
but I haven't used the key option.

Any help would be helpful.

Pete
 
I have several Access databases that I would like to be
able to query at the same time to look up a specific last
name. All my databases have Last Name as the first field
but I haven't used the key option.

Any help would be helpful.

Pete
Click to expand...

Do you have several *DATABASES* - .mdb files which each can contain
multiple Tables, Forms, Reports, etc.? Or do you have several
*tables*?

And how do these tables differ? Having multiple tables with the same
structure is generally not a good design; how are your tables related,
if at all?

Finally, if you're using Last Name as a functional key (even though
you're not using it as a Primary Key) how will you deal with records
for Brown, Brown, Brown and Brown? (By the way, three of these people
are named Fred).
 
Back
Top