Jan 6 2006, 02:37 PM
I have a database with several tables including:
tblSME (subject matter expert) - contact info for intructors (PK = SMEID)
tblCourse - Course info (PK = CourseID)
tblJunctionSMECourse - linking the PK's of the other 2 tables to create a "many-to-many" relationship since most SME's have taught several courses and many courses have been taught by several SME's
I have a form that has a search field at the top (a drop down box- select the SME, and his/her information comes up on the form). Works great. Except I would like to create a subform that lists the courses taught and displays it when the SME is selected as well. How do I do that?
Jan 6 2006, 02:49 PM
Just put a subform control on the form you already have. The subform should of course display the junction table values. Be sure the Link Master Fields and Link Child Fields properties of the subform control are set to the correct values.
Jan 6 2006, 03:17 PM
Okay, I created the subform, but the problem I am having is that it only displays 1 course for each SME. How do I get it to display the whole list of courses taught by each SME?
Jan 6 2006, 03:18 PM
Welcome to UtterAccess!
Make sure the subform is set to continuous or datasheet (I prefer continuous).
Jan 11 2006, 01:28 PM
Still having problems with this form.
I need specifics on where to draw the info. from.
Should the main form record source be the junction table or the instrutor table?
And what about the subform?
And what should the row source be for the drop-down combo box?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here