Tracking places on a course
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.