Hello
Could you please help me with the following issue?
Please see a simplified version of my database below. (The tables are containing hundreds of records.)
STUDENTS
(record1)
id - 1
name - student1
course1 - 101
course2 - 102
course3 - 106
course4 - 109
course5 - (blank)
(record2)
id - 2
name - student2
course1 - 102
course2 - 106
course3 - (blank)
course4 - (blank)
course5 - (blank)
COURSES
101 - editing
102 - acting
103 - directing
104 - producing
105 - screenwriting
106 - documentary
107 - effects
108 - drawing
109 - relaxing
I would like to create a form, what I could use to produce a query showing all students who are attending the selected courses.
For example I would like to see all students attending the "acting" course.
I am selecting "acting" on the form, running the query from a button and getting both records.
The difficulty is that the courses are in different columns (5 columns in total) in the STUDENTS table and I would like to select multiple COURSES and get all STUDENTS attending any of the selected courses.
My idea was to create a form with checkboxes and create a filter based them, but I am lost.
(Please let me know if I have a design error, I can re-design the tables.)
Your help is much appreciated.
Could you please help me with the following issue?
Please see a simplified version of my database below. (The tables are containing hundreds of records.)
STUDENTS
(record1)
id - 1
name - student1
course1 - 101
course2 - 102
course3 - 106
course4 - 109
course5 - (blank)
(record2)
id - 2
name - student2
course1 - 102
course2 - 106
course3 - (blank)
course4 - (blank)
course5 - (blank)
COURSES
101 - editing
102 - acting
103 - directing
104 - producing
105 - screenwriting
106 - documentary
107 - effects
108 - drawing
109 - relaxing
I would like to create a form, what I could use to produce a query showing all students who are attending the selected courses.
For example I would like to see all students attending the "acting" course.
I am selecting "acting" on the form, running the query from a button and getting both records.
The difficulty is that the courses are in different columns (5 columns in total) in the STUDENTS table and I would like to select multiple COURSES and get all STUDENTS attending any of the selected courses.
My idea was to create a form with checkboxes and create a filter based them, but I am lost.
(Please let me know if I have a design error, I can re-design the tables.)
Your help is much appreciated.