how to sum "amount paid" by "product" drop down list to get a balance
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