Limit number of records submitted to Access from FrontPage form

S

Stephanie Trentham

I have a form created in FrontPage which dumps information into an Access
Database. One field "WorkshopDate" is a list box with 4 option dates. I need
to limit the number of 'signups' per date to 28. Any suggestions I could get
on this would be appreciated.
 
K

KARL DEWEY

Use a WorkshopDate field and Signups number field combination as your key.
In your table set the Validation rule for the number field to <29.
 
Top