Total Newbie. I have created an inventory database from the template and have added one more field. It is about a stock inventory for a bar. The issue I am having is: When a bottle of 70cl is taken out of stock, it is being sold at the bar as glasses(calice), 70cl=20 glasses. Only after the 20 glasses are sold that I want that one bottle removed from stock. Please help me with how to write the scrip or calculations to the "glasses" field to reflect the removal of that one bottle from stock. it is the 1st time that I am using FM and I have done research on the issue and have found no solution. Thank you for your patience and understanding. I have attached a screenshot of the database.

I am desperate here guys, please help me resolve this issue. I am sure one of you experts have come across the same problem. Can you please include a screen shot so that i can duplicate more easily what you've done because I have no clue how to do this since I am totally new to FMP.Thanks

You need to calculate the number of glasses with a given volume that a bottle with given volume yields (as in Div ( bottleCL ; glassCL) ), and keep track of the number of glasses sold – which you could probably do by incrementing a number field. When that number is reached, the bottle is empty (at least as far as filling a glass of that volume is concerned).

 

Can you please include a screen shot so that i can duplicate more easily what you've done because I have no clue how to do this since I am totally new to FMP.

 

Do you think that in that case a “screenshot” would really help you?