Access database - help please

  PA28 16:19 18 Feb 2008
Locked

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?

  PA28 18:36 18 Feb 2008

Many thanks - we'll try that. When my son's torn his hair out we'll let you know how we (he) got on!

  PA28 20:49 18 Feb 2008

Thanks guys. Fishmad pete - that link has really given him something to work on - which he is. Many thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

This First Man soundtrack vinyl cover art is exquisitely composed

How to watch Apple’s October 2018 iPad launch

Meilleurs VPN (2018)