Help with forms plzzz

[Steve2010]

Hi there



I am creating a form with a combined three tables to do a booking course form for a customer.

I have created a form for adding a customer and his course.

I have to do the following but I am not sure how I do this, all I know is that I would need to use a dloopup but not sure how, these include

. confirm if the place is available on the course
• confirm how many places are available on the course selected
• show if the customer has already booked a place on the course

Theres are 5 courses, each one allows 20 students, can someone show me a example of how to do this please, really need sum help, would appriciate it very much



What is the easiest way of doing this, would it be Dlookup?

I have three tables

Course table
CourseID
Day
Time
Price
Trainer

Customer Table

CustomerID
Title
Firstname
Surname
Address
Town
PostCode
Telnumber


Booking Table
BookingID
CustomerID
CourseID

The booking is the main table which is the relation with the the other two tables

[Datagopherdan]

Hi Steve,

I have a class scheduling database on my site, which I believe is along the same lines as what you're trying to do. Take a look at it Student Scheduling and let me know if it's along the same thing that you're trying to do and if so, I'll give you a copy where you can see the logic and setup that is being used.

Dan

[Steve2010]

Hi

I have created the database but all I need to do is add the following, but dnt know how!!

. confirm if the place is available on the course
• confirm how many places are available on the course selected
• show if the customer has already booked a place on the course

I have looked at yours, there is a few different things on mine, I just want to add the above things to my database, just need help on that

[pbaldy]

Seems like the DCount() function would get you most of the way. Here's a good reference on the syntax:

DLookup Usage Samples

[Datagopherdan]

Steve,

Paul's suggestion would do the trick. With the sample database that I provided you. You would want to add a field in the course scheduling table to capture the # of students that can be enrolled in a class.