I am working on a table for my organization. Particularly quarterly membership fees.
We have several tables established.
Year / Quarter (table)
Fee Transactions (table)
Parent Tokens (table)
Token Qty Purchased
Token Qty Purchase Cost
Fee transaction table has related
ContactIDfk = Contacts::Contact IDpk
YearQtrIDfk = Year/Quarter::YearQTrIDpk
The Contact Fields and Year Quarter fields are taken from the appropriate table.
We purchase our quarterly member fees from our parent organization. We would like to track the difference of what we purchase from our parent organization versus what we sold to our members.
For examples if we have 400 Fee transactions records in our table.
And have 900 Membership tokens purchased from our parent organization. We would like to come up with an solution to show a true representation or state of our for lack of a better word inventory.
I am very new to FMP , less than a year, and am not grasping this scenario or solution.
Ideally I would like to create a report that states we purchased 900 tokens, sold 400 to the members and have 500 on hand.
Sounds simple enough but I can't grasp it.