Hay,
Here is a clean version of the current database.
It is no where near complete, but my issue is in the "student information" form.
Under the "office use" tab:
Swimming day = Fixed source, monday through friday.
Coach 1/2 = Dependant on day in Swimming day 1/2, from "coaches" table check...
Hay thanks for the reply, unfortunately that is not what I need.
If you can compare the listbox "Coach" to a variable then I want to be able to select times based ON that variable:
IF coach = "Jack" THEN rowsource = "08:00 - 09:00"
IF coach = "Roy" THEN rowsource = "09:00 - 10:00"
So as in...
Hay all,
I need to construct a very complex student/coach/time/day Database.
Every student can attend a lesson twice a week, on a particular day and time with a particular coach.
Every coach has his/her own time table (Days available, times available on those days).
So I want this effect on...