2. ASPRunnerPro General questions
  3. Restrict Number of Records Based on Field Value
This topic is locked

Restrict Number of Records Based on Field Value

 		4/21/2009 9:02:18 AM
ASPRunnerPro General questions
S
 sunnynayak author

Hello,

I am creating an application where there are values in Field "Batch" eg 1, 2, 3
I want to restrict number of records per batch to 25..
so if 25 records are added to batch 1 it should give a message registration full.
Let me know how to do this.
S
 		sunnynayak author 4/22/2009

Someone please help!! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=40367&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
J
 		Jane 4/22/2009

Hi,
I'm not sure that I understand your question.

Where do you add these records? How do you want to filter records (25 records for each master record, 25 records for each user, etc.)?

Please give me more detailed description of what you want to achieve.
4414 4/23/2009

Hi, not sure if I understand your senario correctly, but I do something similar to this. I have an "Events" registration table and a "Roster" table. For each given record in the Events table there is a field calls MaxEnrollment and that is the maximum number of child records for that particular EventID. So on the "Roster" page, it will only allow a record to be added if the total number of Roster entries for that EventID does not exceed the corresponding MaxEnrollment in the Event table. Is that what you are looking for?
S
 		sunnynayak author 4/24/2009

Hi,

I'm not sure that I understand your question.

Where do you add these records? How do you want to filter records (25 records for each master record, 25 records for each user, etc.)?

Please give me more detailed description of what you want to achieve.


The Table name is Register.

Under this there are fields Class and Name and some more.. but these two are what we are looking at.

I want max 25 entries possible for a particular class number.
Sergey Kornilov admin 4/24/2009

I suggest to post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL along with description of what you trying to do.