View Single Post
  #1  
Old March 27th, 2010, 08:36 PM posted to microsoft.public.access.tablesdbdesign
Kathy R.[_3_]
external usenet poster
 
Posts: 25
Default 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.