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!
Microsoft Access 2007
October 25, 2010 10:09 PM
October 26, 2010 4:03 PM