Hi guys, i am new to BC development and just ran into a question.
Right now i am building a contract table for generating contract between vendors & customers, with primary key as "Contract No." Within the document page there is a item line part, which is another table with primary key as "Contract No. " and "Line No.". There is another FlowField in the Contract table which calculates the total of the item unit price in the item line.
What i want to do is each time when i enter a new contract number, the new contract number goes into the Item Line Table, becoming a primary key, and when i select the item on the item line, the flowfield will show the total prices of this specific contract.
Please let me know if you have any ideas. Thank you so much.
My current status:
I add the OnInsert trigger under the contract table to insert the Contract No filed to the Item Line Table Field, and have a FlowField that sums the Item Line Table based on the Contract No. But this doesn't work.
