![]() |
hapony author 6/19/2011 |
Any HELP PLease ? Hi All, i'm new at PHPRunner, and i need help i have 1 table Master and 1 table detail, the table detail has a Alias Field Collum, thats calculate 2 field in current table detail, and i want to sum value on total alias field in table detail, and the result is updated on table Master case example : ============== Master_Table ============== customer_id customer_name service_item total_bill ============== Detail_Table ============== customer_id Sparepartname Price quantity subtotal >> this is alias field with value from calculate price * quantity because it's always more than one record on the Detail_table, so i want to SUM the subtotal and update the result in total_bill field on Master_table I am very grateful if any one could help Regard Boni |