Linking Several people from 1 "person" table..

[andmunn]

Hello,

I have two tables:

1. tblPerson - contains a list of individuals with varying roles. Fields Include:

> First Name
> Last Name
> IsSubmitter (yes/no)
> IsReviewer (yes/no)
> IsApprover (yes/no).

I then have a second table which contains various issues - to which each issue would have a submitter, reviewer, and approver.

How do i link my "issue table" so that i can reference 3 differnt names?

I.E// tblIssue:

pkIssue
txtIssueName
fkPersonID?? how do i link it to multiple people - i'm very confused

Thanks!
Andrew.

 

[okerix]

You have a M to M relationship so you can keep that set up or correctly build additional tables to handle the relationships. If you don't mind the M to M then have 3 personID's one for each position. It's really how ever you want the db structured. To get rid of the M to M you would build a table such as SubmitterTbl and that would hold the IssuetblID and the PersonID.