This topic is locked

To show grand TOTAL generated by detail page on Master list page

2/20/2011 9:31:29 AM
PHPRunner General questions
J
jianwong author

I have a master detail relationship for "Invoice" and "Invoice-Detail" tables.
On Field order & Total, I set TOTAL to the Total field of "Invoice-Detail" to generate a grand total at the end of the detail page. With this grand Total I want it to appear on the List page of the master record - "Invoice".
I tried follow the manual using Insert record into another table and other methods as found in the forum. But all failed. Can anybody advise how to do it? Thank you.
jian