I'm building a database to track presenters and breakout sessions for a
state-wide conference. There will be hundreds of breakout sessions with
one
or more presenters for each session and each presenter could also be
presenting one or more breakout sessions. So far I have tblSessions (with
SessionID as the primary key) and tblPresenters (with PresenterID as the
primary key). I'm trying to create a tblSessionDetails to tie the two
together so I can eventually create a subform within my session form to
assign presenters to each session. When I create the tblSessionDetails, I
can't get any data to come up in the table. When I look at the
relation****ps, there's a one to many relation****p between tblSessions and
tblSessionDetails, a one to many relation****p between tblPresenters and
tblSessionDetails, and also a one to may relation****p between
tblPresenters
and tblSessions. What am I missing to get the data to show up in the
tblSession Details?
