N
Ned
I have a situation where I need to limit the number of records.
We have an ongoing program, where attendees are coming and going throughout
the year. Each attendee is assigned a mentor, but I need to limit the mentor
to only 30 active participants.
So, in my attendee table, I have the fields "name", "status"
(active/inactive), and mentor-id (linked to my mentor table).
If a 31st attendee is added to a mentor, I need to issue a warning and
prevent the record being added.
What's the best way to accomplish this?
Thanks in advance,
-Ned.
We have an ongoing program, where attendees are coming and going throughout
the year. Each attendee is assigned a mentor, but I need to limit the mentor
to only 30 active participants.
So, in my attendee table, I have the fields "name", "status"
(active/inactive), and mentor-id (linked to my mentor table).
If a 31st attendee is added to a mentor, I need to issue a warning and
prevent the record being added.
What's the best way to accomplish this?
Thanks in advance,
-Ned.