AnsweredAssumed Answered

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

Question asked by BobEpine on May 13, 2012
Latest reply on May 18, 2012 by 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

 

Outcomes