6 Replies Latest reply on Aug 25, 2013 7:28 AM by gcatnine

    Help with Look up value for multiple records

    JojoYaya

      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.