I'm setting up a database for a conference to track presenters and breakout
session info. I only have two tables - tblSessions and tblPresenters.
Each
session could have up to 4 presenters so in tblSessions, I set up four
fields
for presenters (Presenter1, Presenter2, Presenter3, Presenter4) that are
combo boxes pointing back to tblPresenters. I want to create a form that
will
show all the session details and all the presenter details. I set up an
autolookup query to automatically fill in presenter contact info on my
frmSession but I can only get it to autofill and display contact
information
for Presenter1. I've tried setting up four different lookup queries - 1
for
each presenter - but when I put them into a form, I can see them in design
veiw, but when I click on form view I just get a blank page. What am I
missing? Or is there a better way to do this?
Any suggestions would be GREATLY appreciated!!
