AnsweredAssumed Answered

Monthly Inventory Count

Question asked by pmac on Jan 6, 2012
Latest reply on Jan 9, 2012 by philmodjunk


Monthly Inventory Count



I've got a database setup that keeps track of all of our beer in kegs and bottles.  I'd like to now develop a way to do our monthly inventory count thru this database.  That way I can use Filemaker Go to do my inventory on my iPhone.  So I've got a table called Beers and a table called inventory (see attached image).  I'd like a way to enter a date once, then have a portal or another table layout where I can simply go down each row and enter the qty counted on that date.  By the way, I only want to count rows that Beers::status does not = "--".  That way it will show me all beers that are on tap, ready to be tapped, or in bottles.

Any help would be appreciated!