AnsweredAssumed Answered

Tracking places on a course

Question asked by Brucey on Oct 8, 2009
Latest reply on Oct 8, 2009 by Brucey

Title

Tracking places on a course

Post

I have set up a relational database for keeping track of the number of places available on a course eg Word processing, spreadsheets, webpage design etc. There are 20 places available on each course.  The tables I have created are Customer_tbl, Course_tbl and Booking_tbl.

 

1. When a booking is made I need to have confirmation in a dialogue box that a place is available and when "OK" is pressed the number of places available is reduced by 1. Perhaps even telling me how many places are left.

 

2. I also need to know if a customer has already booked on a particular course and if so a dialogue box appearing telling me this. eg "This customer is already booked on this course"  

 

 Any help much appreciated. 

 

 

 

Outcomes