B
Bruce
I have a database to keep track of training records. Each
training session is unique, and each is attended by from
one to seventy people. Each employee will attend multiple
training sessions each year. I have handled this with an
Employees table, a Sessions table, and an Attendance table
as a junction table.
I use a form for entering the Session information
(Subject, Relevant Document, Department, etc.) into the
Sessions table. I use a subform for entering attendance
(Name, Date) into the Attendance table. When I open the
form, I can scroll through the training sessions and learn
who was at each one. It works perfectly, as far as it
goes.
Now I need to find a Sessions record based on one of
several criteria. For instance, I need to see all of the
records for a department. I can make a combo box based on
the Sessions table, but of course that shows me only a
listing of departments, some appearing many times.
Clicking any item on the list shows me only a single
record. I need to be able to select a department, then
use navigation command buttons (arrows) on the form to
scroll through all of the Sessions records that have that
department in the appropriate field. In other words, I
need to filter the records based on the combo box
selection, and be able to scroll through the filtered
records.
One more thing I hope to do: filter by multiple criteria,
preferably in any order. I can set up several combo boxes
so that I can search by a choice of fields, but can one
selection be made to restrict the choices in the next
combo box, and does such filtering need to happen in a
particular order? If this is complex I can do without it,
but it could come in handy.
training session is unique, and each is attended by from
one to seventy people. Each employee will attend multiple
training sessions each year. I have handled this with an
Employees table, a Sessions table, and an Attendance table
as a junction table.
I use a form for entering the Session information
(Subject, Relevant Document, Department, etc.) into the
Sessions table. I use a subform for entering attendance
(Name, Date) into the Attendance table. When I open the
form, I can scroll through the training sessions and learn
who was at each one. It works perfectly, as far as it
goes.
Now I need to find a Sessions record based on one of
several criteria. For instance, I need to see all of the
records for a department. I can make a combo box based on
the Sessions table, but of course that shows me only a
listing of departments, some appearing many times.
Clicking any item on the list shows me only a single
record. I need to be able to select a department, then
use navigation command buttons (arrows) on the form to
scroll through all of the Sessions records that have that
department in the appropriate field. In other words, I
need to filter the records based on the combo box
selection, and be able to scroll through the filtered
records.
One more thing I hope to do: filter by multiple criteria,
preferably in any order. I can set up several combo boxes
so that I can search by a choice of fields, but can one
selection be made to restrict the choices in the next
combo box, and does such filtering need to happen in a
particular order? If this is complex I can do without it,
but it could come in handy.