J
Jane
I have a database of courses. The courses have names,
like 'Mathematics', they have unique identifiers and the
have a session. So the Mathematics course held in the
2003/2004 session is distinct from the one held in the
2004/2005 session.
I want to search by first selecting the session from a
drop
down list, then selecting by course name from a drop down
list which only presents the names of the courses held in
that session. ('Mathematics' may not be held every year,
and
some courses are only held once, so the list of courses by
name will be slightly different every year.)
I tried passing the session as a parameter query, but it
didn't seem to work.
What can I do? Any help will be greatly appreciated.
Jane
like 'Mathematics', they have unique identifiers and the
have a session. So the Mathematics course held in the
2003/2004 session is distinct from the one held in the
2004/2005 session.
I want to search by first selecting the session from a
drop
down list, then selecting by course name from a drop down
list which only presents the names of the courses held in
that session. ('Mathematics' may not be held every year,
and
some courses are only held once, so the list of courses by
name will be slightly different every year.)
I tried passing the session as a parameter query, but it
didn't seem to work.
What can I do? Any help will be greatly appreciated.
Jane