G
Grant Thomson
I have a booking form for members of a sports club used to enter multiple
bookings for any one member The main form shows member details and the
subform shows the date, court and time session they want to book. My problem
is this; members have a category type (displayed on the main form), one of
those types means the member is only able to book for a restricetd number of
hours during the day.
When my booking form runs the time session combo shows all the values in the
session table i.e. 9am until 8pm. What I need it to do is only show the
restricted times whenever the member category matches the restricted type.
I created a yes no filed n the sessions table and set it so that the
restricted user times were set to yes.
I know the logi of what it is I wnat to do but have no idea how to make it
work. Can anyone point me in the right direction please?
regards
Grant
bookings for any one member The main form shows member details and the
subform shows the date, court and time session they want to book. My problem
is this; members have a category type (displayed on the main form), one of
those types means the member is only able to book for a restricetd number of
hours during the day.
When my booking form runs the time session combo shows all the values in the
session table i.e. 9am until 8pm. What I need it to do is only show the
restricted times whenever the member category matches the restricted type.
I created a yes no filed n the sessions table and set it so that the
restricted user times were set to yes.
I know the logi of what it is I wnat to do but have no idea how to make it
work. Can anyone point me in the right direction please?
regards
Grant