If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
relationships of 3 tables
Greeings,
I am creating a db to track who serves what function in what Sunday at church. So I think I need 3 tables. 1. people who serve 2. functions they serve 3. dates they serve Many people can serve many dates and many people can serve many functions on many dates. So do I have the three tables and then a join table for people/dates and a join table for people/function and a join table for dates and functions? And how do I structure them. I am thinking: tblPeople peopleID pk name tblFunction functionID pk functionName tblDate dateID pk serviceDate tblJoinPeopleDates peopleID pk dateID pk tblJoinPeopleFunction peopleID pk functionID pk tblJoinFunctionDate functionID pk dateID pk If this structure works, what does the relationship window look like? This is the first time I have tried anything like this. Thanks, Scott -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|