Access database - help please

  PA28 16:19 18 Feb 2008

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

Huawei MateBook X Pro (2019) review

Magical mystery tour - Artist colourfully customises bus to promote positive mental health

Apple Streaming Service Release Date & Apple TV Subscription Rumours

Quel est le meilleur iPad ?