I am an entirely self-taught database creator that has created a few decent databases over the years, but I have a few questions regarding my latest effort for which I could use some help.
I am creating a database that allows students to register for programs. I have one table with their names, email addresses, and additional fields that contain lookups that list program offerings. I plan to send out an email form to each of the students with those offerings, they each reply and select which programs they like in the fields, and then my outlook brings the data back into my access database. I have that much all set to go.
Now the trickier part. I need to set a maximum number of registrations for each program option so that the limits are enforced. For example, if a student sends back an email requesting a program that is closed, it bounces back to them to tell them that and they need to choose a different program. How can I do it? There needs to be a way to limit how many can be registered, and also give the students a chance to try again.
I look forward to any suggestion you fine folks have to offer.
Thanks!
John