One thing I'm assuming (and I'm sure it's a sensible assumption) is that if a record is already booked then a client cannot book it. If anyone thinks differently please let us know.
The other issue I'm having is that in the customer id field of the record the customer wants to book we are supposed to store an 8 digit number (representing the customer id). The question is where does this number come from? How do we generate it?