Button to copy field into another table
So I need a button to do the following:
In child table:
1) When a [status field] = "Work finished" --> button to appear on the form.
2) When button is clicked --> Copy [field w] and [field x] (in the record i am in) to the related parent table [field y] and [field z] respectively.
I could maybe use dynamic for rules for (1), but (2) is a bit tricky for me. Im sure its pretty simple stuff, just need some formula basics to help me on my way.
In child table:
1) When a [status field] = "Work finished" --> button to appear on the form.
2) When button is clicked --> Copy [field w] and [field x] (in the record i am in) to the related parent table [field y] and [field z] respectively.
I could maybe use dynamic for rules for (1), but (2) is a bit tricky for me. Im sure its pretty simple stuff, just need some formula basics to help me on my way.
