one to many relationship in 3 tables

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
 
P

pietlinden

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top