My son is trying to design a booking system for time slots completely in Access as part of a college project. We are having trouble in making the availability of a slot conditional on it not having been booked already.
We have designed a booking form which offers timeslots in the form of a combo list box. We are able to apply validation to eliminate multiple bookings, however we would like the booking form to only offer available time slots (and not to display those already booked). Any ideas how this can be achieved please?