I have a master form with a detail grid.
On the master form I have a field for Invoice Total (inv_tot)
in the detail grid I have a custom button that allows me to select the line items I would like to remove from the invoice.
The only issue I have it how do I update the inv_tot field on the master form to reflect the changes in the invoice total
Reload? Refresh? Not sure how to accomplish this
Dear Keithk
I also have this requirement.
Do you have the solution now?
Thank you!
Good morning,
What I ended up needing to do was change my work flow.
on the master form a created a button “edit invoice items”
when selected that would open up a gris that displays the line item detail section.
On this grid I created a button to “remove from invoice”
then in the OnRecord action for this button where is would grab the current total and the total of the line item and subtract the line item value from the total.
Once this ran I would then hit the back button on this grid application and the grand total would display properly
Let me know if you’d like some of my code examples.
Thanks,
Keith
You can use the macro for update form master:
sc_master_value: ex: [B][B]sc_master_value(‘inv_tot’, $value);
AND update your table in each event (delete. insert, update). [/B][/B]