Relationships

[Guest]

You all have been a big help!
I have two tables. One is for Advisors and one is for Administrators. The
problem is that there is the possibility of several advisors for one client
(CPA, Financial Advisor, Attorney) and many clients having one or more
advisor. I cannot see a way to get a common field to link these fields as I
need all the info for mailing purposes.

 

[Rob Parker]

What you are describing is a many-to-many relationship. The way to handle
this is via a third table, which contains a record for each
advisor/administrator pairing; the table needs to have fields for AdvisorID
and AdministratorID, both of which are foreign keys to the existing tables.

HTH,

Rob