How many Tables do I need?
Ok so I am pretty new to filemaker planning. Here is the problem. I need to make a file that....
I have an excel sheet that has the population in every county in the US.
It has 3 columns. State, County, Polulation.
The population is a "share"
A customer is able to "buy" shares in any amount up to the county max. example... cook county has 1000 population so john can only buy 1000 shares.
So i need a fm file that can keep track of who has bought how many shares in each county.
I am so lost. Please help me.