I am trying to figure out the best way to have FileMaker limit the amount of records that can have the same date based on a number field.
Here is what I am trying to do. We can only build ”X” amount of widgets each day. Each Record entered has a production start date field. Each record also has a numerical quantity field which represents the total widgets required for that record. I would like FileMaker to not allow more records to have the same “Start” date once that date reaches a sum total number of all the widgets booked on that start date.
I hope this makes sense.
Any help would be greatly appreciated.