Selection of only one child record among those with the same parent

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
I want to create a parent / child relationship, where the child records represent different options of the parent record. At any given time, only one option should be the selected as the primary or 'go forward' option. But, I need to be able to change which child record is the primary at any given time. I know I can create a checkbox and then simply check the record that is primary, but then I will have to manually ensure that no other record is checked at the same time. And, I will have to manually ensure that there is always one record that is checked. What I am hoping to accomplish is that when I check/select a record to be the primary, all other related child records (with same parent) will automatically uncheck/unselect to ensure that only one child record can ever be primary at one time. But I also have to make sure that there is always one selected child record for a given parent. Presumably, the first child record created under a parent can automatically be selected/checked as the primary, and then I have the option to change the primary to subsequent child records as they are created.
Photo of Michael Kefauver

Michael Kefauver

  • 80 Points 75 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
You should be able to do this with an Automation.

It will trigger when a child is marked as Primary.

It will then have the Action step to edit records in the children table where the Related Parent matches the Related Parent of the trigger record, but also the Record ID is not equal to the Record ID of the trigger Record.

It will change the field Primary] to Unchecked.