Multiple identical relationships in one Access 2007 table
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
Software/Hardware used:
Microsoft Access 2007
ASKED:
October 25, 2010 10:09 PM
UPDATED:
October 26, 2010 4:03 PM
Answer Wiki:
You want to create a table with a two column primary key.
<pre>CREATE TABLE HouseHoldVolunteer
(HouseHoldId INT,
VolunteerId INT
CONSTRAINT PK_HouseHoldVolunteer (HouseHoldId, VolunteerId))
</pre>
This way you can have multiple volunteers for each household. You then need a HouseHold table which contains the information about each household.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
