Hi, I'm making an automated booking system.
The complete time table looks like this:
Date Session 1 Session 2 Session 3
3/10/11 BOOKED AVAILABLE BOOKED
3/11/11 BOOKED BOOKED AVAILABLE
3/12/11 AVAILABLE BOOKED BOOKED
Now I need to show which sessions are available on a particular date.
The user is to select the date from a drop-down menu, and the available sessions for that day is to be shown in a list box below.
The form should look like this:
Uploaded with ImageShack.us
I have managed to link the combo box to the dates but how do I separate the available sessions from the complete table to show only the available sessions? If I could separate the available sessions in a new range I could then link the listbox to that range
The complete time table looks like this:
Date Session 1 Session 2 Session 3
3/10/11 BOOKED AVAILABLE BOOKED
3/11/11 BOOKED BOOKED AVAILABLE
3/12/11 AVAILABLE BOOKED BOOKED
Now I need to show which sessions are available on a particular date.
The user is to select the date from a drop-down menu, and the available sessions for that day is to be shown in a list box below.
The form should look like this:
Uploaded with ImageShack.us
I have managed to link the combo box to the dates but how do I separate the available sessions from the complete table to show only the available sessions? If I could separate the available sessions in a new range I could then link the listbox to that range
