Results 1 to 2 of 2
2004-04-17, 13:21 #1
- Join Date
- Jan 2001
- Denver, Colorado, USA
- Thanked 0 Times in 0 Posts
Update table field based on event (Access XP)
I am using Access XP as back end for a Web-based calendar application. I want to be able to enter class information in tblClasses and enter a maximum number of students who can attend (numMaxAttending).
Students can register for a class and their information is stored in tblRegistrants with a foriegn key of the Class ID.
What I want to do is update a field that when the number of registrants equals the maximum allowed this field is checked indicating the front-end Web application to stop allowing registrations.
2004-04-17, 17:53 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Update table field based on event (Access XP)
I believe you're going to have to do this from your web application, not from Access, since Access doesn't support triggers. What you could do is add a Closed yes/no field to your registrations table and test it whenever a registration is attempted. When a registration is added for a class, test the number of registrations for that class against the maximum number and when it is reached, set the Closed field to Yes. That prevents your having to do any more counting unless someone withdraws a registration.Charlotte