I need help with programming my solution, i have got up to choosing seats in a bookings system. However the specification requires that i allow prevention of double bookings. My teacher and classmates are unsure of how to do it.....
If you are using VBA you could do a DLookup on the seat is to see if it has been already booked.
In pseudo code it would be:
If Seat_ID exists in BookedSeatsTbl then
Output "seat already booked"
Add seat to booking.