how to update/commit records between two portals in the same layout
I'm using filemaker pro advanced 11 on mac os x and am relatively new to filemaker with a good technical background.
Now I'm trying to develop an inventory and accounting solution for a trading firm.
The firm purchases products from a manufacturer.
A layout is used to input the firm's purchase document i.e. manufacturer's invoice which has several products in one portal and multiple taxes in a second portal.
The layout shows records from the 'purchase' table (with pk PurchaseID),
products portal has related records from 'purchaseitems' table (with pk PurchaseID),
taxes portal has related records from 'purchasetaxes' table (with pk PurchaseID).
The problem I face is, if data in products portal is modified, then the corresponding calculation of taxes is not updated since the tax records are in a different portal whose records are not committed.
How do I commit records in the taxes portal based on changes in the products portal?
Is there a better approach to solve this problem?
Any help will be appreciated.
Thanks & Regrads.