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!