Copy registers from one table to another according to specific conditions
Posted: 2020-10-06 16:05
Hi all!
I was trying to find some information/tips about having an action button (or modifiying an existant one) to do this:
- I have a parent_table, a child_table and a master_table and what I want to do is:
1) I create a register in the parent_table
2) If the field1 of the parent_table equals the field2 of the master_table, then I want to retrieve some columns of a record from the master_table and copy them to the child_table
3) I would like to retrieve not just the columns from one record but from all registers that match the condition (parent_table.field1 = master_table.field2)
I tried to find a post talking about this but couldn't find any.
Thanks in advance
I was trying to find some information/tips about having an action button (or modifiying an existant one) to do this:
- I have a parent_table, a child_table and a master_table and what I want to do is:
1) I create a register in the parent_table
2) If the field1 of the parent_table equals the field2 of the master_table, then I want to retrieve some columns of a record from the master_table and copy them to the child_table
3) I would like to retrieve not just the columns from one record but from all registers that match the condition (parent_table.field1 = master_table.field2)
I tried to find a post talking about this but couldn't find any.
Thanks in advance