How to allow two choices?

[vapid2323]

Ok I know this must be simple but I just can’t get it.

I have a table 'Audit' and it has a bunch of fields including one to select the 'Auditor'.

I need to be able to select more than one Auditor for each record in the Audit table. I thought that I could use a Auditor table and just setup a fk in the Audit table, but when I try to set that a second time (for the second auditor if needed) it tells me that it will no longer be able to enforce the referential integrity.

I think I cooked my brain for the last 3 hours trying to get this on my own... Now i need help!

 

[vapid2323]

Ok I think I just got this answered from my other post lol >.<

I might have had it right from the start! I hate it when I change something and then make it worse!

TO see that post please look at http://www.access-programmers.co.uk/forums/showthread.php?t=204309

 

[MarkK]

But what's your solution? What did you figure out?
If you post that info then this thread is more valuable for others.
Cheers,

 

[vapid2323]

Well my solution was to go back to the original plan found in the other post.

Since I had time to think about things before you where nice enough to post I had made changes by removing the Join tables. I had thought that I might not need them.

But as it turns out I was making my situation worse by trying to fix something that was not broken. I found that out after I revived the post you made (use the link above to see that post)