I am trying to group family members by assigning an unique ID under one column.
What is desired is to have an entry (a form from one member) to multiple select members from a list, and when that happens, the app will have an action to automatically assign an unique ID to the original member together with the members selected.
I would love to do it this way instead of creating another table to build the relationship as I feel it reduces manual inputs and minimises additional tables needed.
I’ve been exploring and need some inputs here. Have explored Behaviour/Action/Do This/ Data: set the values of some columns in this row but Im struck here.