David R
11-30-2001, 02:55 PM
I'm updating a form for my database (see http://www.access-programmers.co.uk/ubb/Forum2/HTML/001198.html for the details on it). However I'm not sure if I can create the subforms the way I want to.
frmParticipants has three subforms: sfmDevices, sfmAutomobile, and sfmEvents. tblEvents is only linked to tblDevices (which is linked to tblParticipants) though, not tblParticipants directly. The form currently displays all events, instead of the ones that this participant has attended. When I try to link Master/Child fields it tries to ask for a parameter (presumably because the linking field, EventID, is not in the main table, only the one which joins the two many-to-many). How do I get around this? My coding skill is serviceable so if that is required it will work, but I think I'm probably missing something simpler.
I tried making the subform over with the wizards, which set the Master/Child links properly. But when I moved the subform out to the main form (since it's not really a subform, it's a many-many form) it broke those linkages. Would using full names for the Master/Child fields help?
TIA,
David R.
frmParticipants has three subforms: sfmDevices, sfmAutomobile, and sfmEvents. tblEvents is only linked to tblDevices (which is linked to tblParticipants) though, not tblParticipants directly. The form currently displays all events, instead of the ones that this participant has attended. When I try to link Master/Child fields it tries to ask for a parameter (presumably because the linking field, EventID, is not in the main table, only the one which joins the two many-to-many). How do I get around this? My coding skill is serviceable so if that is required it will work, but I think I'm probably missing something simpler.
I tried making the subform over with the wizards, which set the Master/Child links properly. But when I moved the subform out to the main form (since it's not really a subform, it's a many-many form) it broke those linkages. Would using full names for the Master/Child fields help?
TIA,
David R.