Hi, I am hoping someone could help me.
I have created a form that allows a Member of a club to make a booking for an Event at a certain date and time. Is there a way to check that before the new entry is added to the table that the Member who is making the booking has not already booked a different Event on the same date and time?
I have used a composite key of Member ID, Event ID, Date and Time to ensure the member is unable to book the same event at the same time. This does not solve the problem above however.