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
|
|||
|
|||
many-to-many table setup?
I am having trouble figuring out how to set up tables/fields for the
following problem. Can someone please point me in the right direction? I currently have three tables: tblIndividual IndID FirstName LastName tblAttendance (join table between the other two) AttendID AtIndID AtEventID tblEvent EventID EventName other event info I have been asked to include a field which would keep track of options each individual chooses for each event. Currently there are three options (receive newsletter, receive a call, join), but I can envision adding more in the future. An individual can choose none, one, or more than one of those options. I was thinking that I should add another foreign key to tblAttendance, and a new table of event options. But I just can't seem to picture how that is going to work. Do I store all of the options chosen in one field? That doesn't seem right either. As you can see, I am just getting more confused. Once I get the tables set up correctly, how do I set up the form so that I can easily choose the options? I suspect that I will be able to figure this out easily once I see the table set up, but thought I'd ask in advance. I really appreciate any help you can give me. Kathy R. |
Thread Tools | |
Display Modes | |
|
|