AnsweredAssumed Answered

efficient count calculations

Question asked by ericjlindholm on Jan 8, 2014
Latest reply on Jan 8, 2014 by philmodjunk


efficient count calculations


     I have a table with master inventory items with a record "Microphone A".   There is a portal to a table of sub inventory Items that lists the serial numbers and barcodes of all of the Microphone As I own.  I have a status field in the sub items table.  I want to display a count of sub items with a specific status such as "Active".  What is the most efficient way to do this?  Thank you