I am building a volunteer contact management database. I have a table titled “Volunteers” that contains contact information fields and links to other databases with information about hours accrued. The Primary Key in this table is “VolunteerID”. I want to somehow be able to associate different volunteers with each other in “Households”, another table. My problem is that I cannot create a table that contains this information: HouseholdID (Primary Key) VolunteerID1 (linked as a foreign key from the primary key in “Volunteers”) VolunteerID2 (also linked as a foreign key from the primary key in “Volunteers”) Is there any way to create a relationship here between VolunteerID1 and the VolunteerID field in the “Volunteers” table, and between VolunteerID2 and the VolunteerID field in the “Volunteers” table? Or is there a simple solution to this contact management problem that I am missing? Thank you!

Software/Hardware used:
Microsoft Access 2007