1 2 Previous Next 19 Replies Latest reply on May 18, 2012 6:17 AM by BobEpine

    how to sum "amount paid" by "product"  drop down list to get a balance

    BobEpine

      Title

      how to sum "amount paid" by "product"  drop down list to get a balance

      Post

      Hi all,

      Hope somebody can help me out. Wink

      I'm new to filemaker and I'm working on a solution to track the daily amounts payed by each client.

      I am using filemaker pro 12 advance

      Got 3 tables - clients - lines - products witch are related KP_client_id - (KF_client_id -KF_product_id)- KP_product_ID

      Allow creation are set to lines from Client and and from Products

      There are 3 products prod1, prod2, prod3

      The lines table has fields kf_product_id indexed by value list, Amount paid and timestamps ..

      The client table has Prod1_due = (auto-enter with a fixed amount ex:$25), Prod2_due, Prod3_due and Prod1_balance, etc..

       

      I need to find a way to get the balance due for every product. I can't filter the sum by products

      I hope I got enough infos.

      Help please. thanks

       

        1 2 Previous Next