Only allow a certain amount of children

I want the user to be able to add only max 4 children to a parent record.
In the child’s Add Action I tried
COUNT([ParentID].[Related Children])<4
but this is not working.

Solved Solved
0 3 264
1 ACCEPTED SOLUTION

With some sleight modification to this sample app you can achieve what you want; it’s just a matter of changing the criteria for the actions.

Check out this sample app to see how I did it:
https://www.appsheet.com/samples/An-app-that-demonstrates-how-to-control-when-child-records-are-crea...

View solution in original post

3 REPLIES 3

With some sleight modification to this sample app you can achieve what you want; it’s just a matter of changing the criteria for the actions.

Check out this sample app to see how I did it:
https://www.appsheet.com/samples/An-app-that-demonstrates-how-to-control-when-child-records-are-crea...

Thank you Matt that’s helpful.
When I understand it right, you disable the child’s ADD Action. Instead of that you use a LINKTOFORM() Action in the Parent table.
Maybe I should go this way.
Because what I wanted to do is: control the “ADD” in the Child’s table.

Yup, that’s the ticket!

Top Labels in this Space