I’m using Knack to approve/deny requests to host high school athletic events. We now want to limit how many tournaments can be played on any particular date. In particular, we want to limit one sport to three tournaments on any given date. I’ve created a related table so that every tournament requested’s date and sport are created in this table. If I generate a unique key field off the date and sport, is there a way to create the record in the related table, but if it already exists, update the related record? I’m trying to stay away from Javascript if at all possible. I’m not that experienced with Javascript.
I think this has been asked before but I can’t remember. You might try a search.
One crude way may be to do a count of the child records and if it equals 3, hide the Add form or button.