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.

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-created?appGuidString=e84d6be8-8fb8-4930-b968-aa1ac8d37b72

2 Likes

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.

1 Like

Yup, that’s the ticket!