Skip to main content
Question

Limiting the number of child records that can be created

  • July 14, 2022
  • 0 replies
  • 99 views
I have a child table that a user is only meant to be able to make 1 record for each parent. Is there a way to limit the user's ability to create more than 1 child record?

------------------------------
Chris Swirtz
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,
There are two parts to the method.

The first is to make a summary field of the # of children.  Then make a form rule on your parent form to hide the add child button if the # of children is greater than zero.  Also, users can add children in Grid Edit Mode, so best if you can have the embedded child table not be going into grid edit mode when the parent is in edit mode .

Also,  go to the roles settings and for every role set the User Interface to block the add record button.  Note I'm not talking about permissions, they do need Add permission, but the user interface so they can't just go to the child table and add a record test that way.

​​

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement