Forum Discussion

MichaelKefauve1's avatar
MichaelKefauve1
Qrew Member
7 years ago

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

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 'g...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.