M
melwheels
I'm trying to create a form to simplify a somewhat complex scheduling
task.
I have individuals attending tests that take place at a given date and
session (AM or PM). For each individual/test, I have to assign both a
room and a supervisor. I want to create a pick list for the rooms,
and a pick list for the supervisors. Each room or supervisors can
only be used once per session (exception described below). I want the
pick list to display only available rooms, and only available
supervisors. So if the room or supervisor have already been scheduled
for that date/session, they don't appear in the list.
To complicate things, there is one room that can be used more than
once (called ET). If the ET room is used, then the supervisor
assigned to that room for that date/session can still appear in the
list, but only if the ET room is selected for that date/session.
Clear as mud, yes? :-/
I'm working from a table, which I'm not able to change, as it is part
of a bigger application used in other places. This means that the
"magic" has to happen either at a query and/or form level.
I fear I'm not making much sense, but I hope you can help me.
Thanks
Melanie
task.
I have individuals attending tests that take place at a given date and
session (AM or PM). For each individual/test, I have to assign both a
room and a supervisor. I want to create a pick list for the rooms,
and a pick list for the supervisors. Each room or supervisors can
only be used once per session (exception described below). I want the
pick list to display only available rooms, and only available
supervisors. So if the room or supervisor have already been scheduled
for that date/session, they don't appear in the list.
To complicate things, there is one room that can be used more than
once (called ET). If the ET room is used, then the supervisor
assigned to that room for that date/session can still appear in the
list, but only if the ET room is selected for that date/session.
Clear as mud, yes? :-/
I'm working from a table, which I'm not able to change, as it is part
of a bigger application used in other places. This means that the
"magic" has to happen either at a query and/or form level.
I fear I'm not making much sense, but I hope you can help me.
Thanks
Melanie