link table fields between two databases

[Guest]

I have two databases, say 1 & 2. 1 Has a table with contact info, training
date info, and sales info. Database two has a table with contact info,
customer info, and invoice info. I want to link the contact info only
bewteen the two databases, but I only want a few records from database 1 into
database two, not the whole table. Is there a way to do this? Thank you all
that respond!

Brad

 

[Steve Schapel]

Brad,

There would possibly be a number of ways of doing this, and the best way
could depend a lot on what you want to do with the data. A likely
contender would be to link from database2 to the table in database1, and
then construct a Union Query in database2 to combine the selected
contact info from the database1 table with the contact info in the
database2 table.

If that doesn't point you in a useful direction, maybe you could post
back with some more details of the data and what you are really trying
to do, with examples.

 

[Guest]

Steve,
If db1 has 30 records, but I only want specific ones, is there a way to
choose, say based off someones name or ssn?

 

[Steve Schapel]

Brad,

Yes, you would use selection criteria in a query, in the usual way.