one to many relationship in 3 tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three tables I need to relate. One is an Event table and for each
Event, there can be many sessions (that relationship is easy). Then I need to
relate the Sessions table to the Members table as there can be one Session
with many members attending. It seems simple to make a one-to-many
relationship between Event table and the Session table, and then another
between the Session table and the Members table.

But my problem comes when I try to create a data entry form that lists the
fields from the Event table and the various Sessions information and the
Members at each session. All I can find only shows how to link two tables and
show that on a form by making the Primary table the basis for the form, and
the foreign table a subform. How do I get the 3rd table (I guess it would be
a sub-subform?) represented on the form?

Any ideas?

Thanks, Gina
 
Event--(1,M)--Session--(1,M)--Attendance--(M,1)--Member

Attendance PK is (SessionID, MemberID)

You should be able to nest like this:
Event - single form
Session - single form
Attendance (combobox for Members.) - format as datasheet if you
want

HTH
Pieter
 
thanks so much for the info...are you saying I should have FOUR tables? it
looks like you have the Event, then the Session, then the Attendance and then
the Member? what is difference between Attendace and Member?

I'm going to try it...thanks again, gina
 
Back
Top