AnsweredAssumed Answered

Performing calculations on multiple records within a related table

Question asked by SamuelAgnew on May 17, 2011
Latest reply on May 17, 2011 by philmodjunk

Title

Performing calculations on multiple records within a related table

Post

Hello I have made a database with two tables: one containing customer info and order total and another that contains payments. Using portals this allows me to add many payments for each customer. The problem is that I now want to calculate the amount payable by subtracting the total of all payments from the order total, but cannot figure out exactly how to go about it as simply using a calculation only subtracts from one record(payment). I'm sorry if this question has been asked before or is painfully simple but I am a complete novice.

Outcomes