I’m facing the following issue. Value is not written to the database (MSSQL). I have two tables: Order and Items (multiple Items per Order) In Items I have an Amount value In Order I have a Total field which is a formula to Sum the Amount in all the relating Items.
I start with creating a new Order,
click on Add to add an Item,
Creating an Item,
Click Save on the Item (it goes back to the Order) I see the correct Total on the screen I click Save, it syncs. BUT the database has zero in the Order Total. Any idea what can it be?? Editing the Order at a later stage, (the formula is recalculated) and clicking save it Does appear in the DB. Looks like the order of the sync is wrong or something, the Order is written before the Items so it gets Zero as the total (??) Thanks
P.S. This is the formula in the Order:
=SUM(SELECT([Related dbo.OrderItems][Amount Currency], [PO#]=[_THISROW].[PO#]))