Master Form/ Sub Form

[cindyLiu]

Hello Expert,



I have Master Form (Frm_StudentMain, Table: TBL_Student_main), and Sub Form (Frm_CourseDetail, Table: TBL_CourseDetail), and both forms link by student_id.

On the sub form, I use 3 combox to display course name1, course name2, course name 3. (TBL_courselist for combox, and fields are :student_id, course_id, course_name). All the students have chosen courses but they are differently;

Here is my question:

On these 3 combox drop down list, they should only show the courses which related with this student.

How do I do this?

Thanks,
Cindy

[orange]

Please post your tables and relationships (jpg/png).

Students--->StudentSelectedCourses<---Courses

[cindyLiu]

Thank you very much!

[cindyLiu]

[cindyLiu]

this is the table (Tbl_course detail) for Subform, and FirstCourse, SecondCourse, ThirdCourse should come from the combox in the subform.

[CarlettoFed]

Does every student have to select three courses?

[cindyLiu]

This is just an example. some students might only have one course, some students might have 5 courses. but the subForm only shows 3 courses.

[orange]

Why is this?

some students might have 5 courses. but the subForm only shows 3 courses.

[cindyLiu]

sorry, I just used the course as examples. Actually, I am dealing with disabilities.......with services.....

[orange]

Perhaps you could post a copy of the database - remove anything confidential - so we can see the issue in context.
We often see analogies which can confuse the underlying requirement.
A more appropriate, normalized structure may exist.

It isn't clear if a course is offered at different times/days. I'm trying to understand your Mon, Tues, Wed fields. I think your tables structure could be improved, but only you know the real requirement.

[cindyLiu]

how to post an Access database here?

[orange]

Run Compact and Repair, then make a Zip of your database.

The attach process is here

[cindyLiu]

ok, I just made a simple access database. please see.

[cindyLiu]

On table TBL_RecoveryServiceDetails, for FirstService, I used the lookup, but it didn't work.

[davegri]

Would this sort of layout work for you?

TestDB-davegri-v01.zip