Limit Portal Entries

[ejpvi]

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.

[efen]

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