Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Denver, Colorado, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update table field based on event (Access XP)

    Hello,

    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.

    Thanks, joe

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •