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.
Discuss This Question: 1  Reply