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:


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!