Hi people
I am trying to get a combo box to display a set list depending on the values in a table. I have a form which takes booking details for PC's and on this form is a combo box which shows available time slots. I want this to be restricted by whether time on that day and on a specific computer is available or not. At present i have a query which gets all the bookings for a specific day and specific computer. I also have a lookup table which stores all possible time slots. How, if possible, could i write a query that restricts timeslots to that which are not in the table returned by my origina query.
I can't help but think that this will be simple but i really can't figure it out.
Any help would be much appreciated.
Thanks
I am trying to get a combo box to display a set list depending on the values in a table. I have a form which takes booking details for PC's and on this form is a combo box which shows available time slots. I want this to be restricted by whether time on that day and on a specific computer is available or not. At present i have a query which gets all the bookings for a specific day and specific computer. I also have a lookup table which stores all possible time slots. How, if possible, could i write a query that restricts timeslots to that which are not in the table returned by my origina query.
I can't help but think that this will be simple but i really can't figure it out.
Any help would be much appreciated.
Thanks
