centurion 5

Below is an extract from my code.. 1) insert code works fine, then.. 2) retrieves inserted record ID 3) then it SHOULD update the status of the performance with "booked" But it doesnt seem to update.. any ideas? [CODE]<% sql="INSERT INTO bookings (performanceID, customerID, bookingDate)" sql=sql & " VALUES " …

Hi, I am building a cinema booking system in ASP/VbScript with MS Access. I would like to display the records from the recordset in form of: [-----STAGE-----] [B] [x] [x] [x] [x] [x] [x] [B] [x] [x] [x] [B] [x] [x] [x] [x] [x] [x] [x] [x] [x] [x] [x] …

New to the forums, hope my stay is a good one.. thanks Centurion 5