Hi, I have a table called “Sites”.
Child tables to this are
- “Site Tests” - Ref is Site Name 2) “Site Orders” Ref is Site Name 3) “Site Payments”
Ref is Site Name
Users enter data in Sites and anybody can create Sites and child table rows as well.
I have seen that users enter data wrongly and new site records (duplicates) are created for the same site. Also for the duplicate sites sites created, some child records are also created.
Can I create a view / form to select the Site Name which is wrongly created and the Site Name to which I want all the child records can be moved to? After the move is done, I will delete the wrongly created one.
I think I can do with Action “Data Execute action on set of rows”, but I have not seen any example on this… If I am right, please share me an example here or you may please suggest how to do this.