June 2, 201015 yr Hi, I am wondering if there is a way to Limit how many records can be created in a portal. For example... I am recreating a form in FMP.. I wanted to use a Giant Portal, that has all of the different Fields being used. The catch is, I only want to allow at max, 12 rows of data per 1 Parent Record. What usually happens is the portal extends to allow more records, I don't want that to happen. I want it to stop at 12. I am trying to make it fit perfectly on a sheet... and I don't want to allow anything over 12... I know another way of doing it, but it requires a lot more time and work setting up a page simply for submitting data... this would save me a lot of time if I could have them just key it directly into the portal.
June 2, 201015 yr In your script to create the portal row record include a subscript at the start to test for the number of rows pseudo code If Count(relatedtable::keyfield)= 12 Show dialog "error - maximum number created"; OK Halt script End if
Create an account or sign in to comment