AnsweredAssumed Answered

Creating a count based off two fields

Question asked by FM_DM on Nov 11, 2014
Latest reply on Nov 13, 2014 by philmodjunk

Title

Creating a count based off two fields

Post

Hi

I am a complete novice at filemaker so forgive me if I am a little unclear. I am creating an office inventory system with individual records for each item. What I would like is a box showing the current number of that item we have in the office. Location is determined by a dropdown box which also contains the location name Office - Faulty. I would like only to count records which have the same name as the current record being browsed and have the location as Office omitting office -faulty - essentially creating a box which automatically updates to show current number of that item in stock which are usable.

Is this possible? I don't really know where to start.

Outcomes