I have a list of members of my lab in one table. In another, I have a list of the experiments we have running right now. There is a field called 'chair' for the person in charge of the experiment, and a field called 'coder' for the person who wrote the experiment. Both are members and relate to the members table. However, I can only use referential integrity when the memberID is related to either Chair or Coder. How can I do it for both?

I want to be able to see in the members table (+)'s who is working on what, whether coder or chair.

thanks!

In the relationship window, add the members table a second time. Access will suffix it with _1 - then draw a join line from the new instance to the second field. You will be able to enforce RI on both relationships.