Is there a way to enforce a parent's form rules on a child table's field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a parent table called Projects and a child table called Actions.

On the Projects main form, the "Add Actions" button and Actions embedded report are displayed.

My question is, when a particular event takes place on the Projects main form (a status change, for example) is there a way to require users to create an Actions record? 

Photo of Bryan

Bryan

  • 40 Points

Posted 3 years ago

  • 0
  • 1
Well you cannot cause their chair to electrocute them, but you can put up a warning on the parent record that it is missing an Action record.

Another approach would be to have the Child table be the one where the status is actually set, and then use a reverse relationship to float up the most current action to the parent and use that for the status.  ie the status on the most current Action record is the only way to update the status of the parent.
Photo of Bryan

Bryan

  • 40 Points
Thanks. That's what I figured, but I had to do my due diligence to get confirmation.

The reverse relationship won't work in this case, but it will work in another one of my applications. Thanks for the tip!