Double Booking

[Chester1]

Hi

I am trying to avoid being able to do double bookings in a form. I have a
combo box holding 3 options eg AM PM All Day. Based on the date of the
booking if it is ALL Day then I would like the combo box to be blank if PM is
booked on a particular date then I would like only AM to be available. I
hope this makes sense and that someone can give me Basic! instruction on how
to do this.

 

[Noëlla Gabriël]

Hi Chester,

if you really want to avoid double bookins I thing creating an unique index
on the combination of fields that should remain unique is the easiest way.

 

[Douglas J. Steele]

See whether what Allen Browne has at
http://www.allenbrowne.com/appevent.html helps.