AnsweredAssumed Answered

Help with Look up value for multiple records

Question asked by JojoYaya on Aug 24, 2013
Latest reply on Aug 25, 2013 by gcatnine

Title

Help with Look up value for multiple records

Post

     Greeting,

     I have 3 tables : Customers, Bill, Payment

     I give an example---> In the "Bill", a customer need to pay an amount of "200". He pays this amount separately ( which are 100 for the first payment, 50 for the second payment, and another 50 for the third payment)

     I am going to print out the receipt for this customer (using Layout :Payment) The first receipt looks like this:

Total Amount Needed to be Paid:    200

Total Amount Paid Today:    100

(This is a number field; LookUp Value)Total Amount Paid Before:        0

Balance:  -100

     And then,the second receipt:

Total Amount Needed to be Paid:    200

Total Amount Paid Today:      50

(This is a number field; LookUp Value)Total Amount Paid Before:    100

Balance:  -50

     But I am having problem with the third receipt:

      

Total Amount Needed to be Paid:    200

Total Amount Paid Today:      50

(I have the problem here, i need this field to show the total amount of last two payments-which should be 150 and not 100)

Total Amount Paid Before:    100

Balance:    -50

     i want it to look like this:

      

Total Amount Needed to be Paid:    200

Total Amount Paid Today:      50

(This is a number field; LookUp Value)Total Amount Paid Before:    150

Balance:       0

      

      

      

     How can i make it? I googled highs and lows and still cant find the solution. I desperately need someone help......Thank you so much.

Outcomes