CODEWITHSUNDEEP
ms-accessms-access-2010
Lei-Lonnie
Lei-Lonnie

Reputation: 784

How do you link info from other tables in ms-access?

I'm doing a mail merge from an Access Database. Most of the fields are coming from one table, but I have one field which lists an assigned person to a contact. I want to display that assigned persons contact info–which is in a separate table–to display in the merge.

Is there a way I can populate that assigned person field with a reference, or link to the record in the second table?

What's the best way to do this?

Upvotes: 0

Views: 35

Answers (1)

Gustav
Gustav

Reputation: 55981

Use a select query that joins the two tables on the person id.

This is so basic that it sounds like you really need to study some intro tutorials for relational databases.

Upvotes: 2

Related Questions