mobarak ahmed
Member
- Local time
- Today, 08:40
- Joined
- May 28, 2021
- Messages
- 95
hi Friends , i have contract form which contain Contract_details subform
every contract have his own details items
in invoice form i have feild called invoice value
it should be sum of "item_Value_Current" in contract_details table
now i want When I choose project name , the items of this contract appeared in invoice form according to contract_details table
in order to write the current progress value in "item_Value_Current" and the sum of this cell appeared in "invoice value " in invoices form
notice : every invoice has it's own "item_Value_Current"
"item_Value_Previous" is the sum of all previous "item_Value_Current"
"item_Value_Total" is sum of Previous and "item_Value_Current"
after this report "Invoices" should show every invoice with it's own details
can use project name "tagreba" and "Tagreba2" to try as i add items value in both of them
every contract have his own details items
in invoice form i have feild called invoice value
it should be sum of "item_Value_Current" in contract_details table
now i want When I choose project name , the items of this contract appeared in invoice form according to contract_details table
in order to write the current progress value in "item_Value_Current" and the sum of this cell appeared in "invoice value " in invoices form
notice : every invoice has it's own "item_Value_Current"
"item_Value_Previous" is the sum of all previous "item_Value_Current"
"item_Value_Total" is sum of Previous and "item_Value_Current"
after this report "Invoices" should show every invoice with it's own details
can use project name "tagreba" and "Tagreba2" to try as i add items value in both of them
Attachments
Last edited: