anyone know how to prevent double bookings in WJEC Computing coursework?

  • 0 votes

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.....

HELP!

Posted Sat 9th March, 2013 @ 16:50 by Tom

2 Answers

  • 0 votes

What language you using?

Answered Thu 2nd May, 2013 @ 10:23 by Ed Spooner
  • 0 votes

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"
Else
Add seat to booking.

Answered Mon 4th November, 2013 @ 16:19 by Joefletcher