Hi
I have a form which displays full information for a staff member, and at the bottom of the form is the staff number and name of their manager I have a button on the form which when pressed, should overwrite the staff information and replace it with the managers information... If that makes sense?
I have written the following on the WHEN-BUTTON-PRESSED trigger:
SET_BLOCK_PROPERTY('hractivemp', default_where, 'where :supervisor_no = :emp_num');
I have tried it with the execute_query after this, but when the button is pressed it just clears the record.
If I put execute_query before it, it replaces the staff details with a random staff member from the table and not the manager as it should.
What am I missing, and where about's should I have the execute_query?
Thanks in advance for your help.