AnsweredAssumed Answered

Possibile to create an inventory type table from information held in already established table.

Question asked by dennismoorejr on Dec 7, 2017
Latest reply on Dec 9, 2017 by dennismoorejr

I am working on a table for my organization.  Particularly quarterly membership fees.

 

We have several tables established.

 

Contacts (table)

ContactIDpk

Name

Address

Phone Etc..

 

Year / Quarter (table)

YearQtrIDpk

Year

Qtr

 

Fee Transactions (table)

TransIDpk

YearQtrdIDfk

ContactIDfk

Trans Date

Amount

Check No

 

Parent Tokens (table)

ParentTokenIDpk

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.

Outcomes