Is there a way to keep a record from being accepted? I'm guessing with
vaildation somehow, but I can't get my mind to work!

I am putting a scheduling solution together. I can have a maximun of 50000
scheduled for each work day. If you try to enter more than is available on
that day, you can't enter the record and have to choose a new day or the
solution would suggest the next available work day.

Thanks in advance!

Forgot: v8 and 8.5.


"MuniciNET" <dan (AT) mmsit (DOT) net> wrote

In article <lcedncDak9zA1NfYnZ2dnUVZ_tOdnZ2d (AT) lbdsl (DOT) com>,
"MuniciNET" <dan (AT) mmsit (DOT) net> wrote:

A method that occurs to me is to make a self-join on table, using the
Date field for the relationship. The define a field that returns the
Count of the records in the related self-join table.Impose a validation
requirement on the key ID field or on the data field that displays a
message if the Count has reached the limit.

--
For email, change <fake> to <earthlink>
Bill Collins