My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Form Subform Junction Table
|
|
 Jan 6 2006, 02:37 PM
Post
#1
|
|
|
New Member Posts: 5  |
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? Any suggestions??? Thanks, Lance |
 |
 
|
|
Jan 6 2006, 02:49 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
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
Post
#3
|
|
|
New Member Posts: 5 |
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
Post
#4
|
|
|
Head Wizard Posts: 14,857 From: South Carolina, USA |
Welcome to UtterAccess!
Make sure the subform is set to continuous or datasheet (I prefer continuous). |
|
|
|
|
Jan 11 2006, 01:28 PM
Post
#5
|
|
|
New Member Posts: 5 |
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? |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 05:25 PM |