Hope this isn't a dumb question. I know how to get summary info...but I need to get the total of items of the same named field. Example... field 'item' has 3 records with the term 'guitars'. One record has 2 in the quantity # field, another has 3, and another has has 4...so the total would be 9 guitars. Three records with 'guitars' entered in 'item' field...how do I get the summary total of JUST guitars...not all others...pianos,etc. Does this make sense? Thanks.

I'll assume this is an invoice or PO and we're talking about related line items.

You could for example make a relationship that includes both invoiceID::invoiceID, and globalItem::item. Here "globalItem" is a global field of type text. Let's call this relationship theItems.

You could use a script to set globalItem to "guitars" and then get the total with Sum(theItems::quantity).

A different way to do it would be to make a calculated number field in the related file like so: Case(item="guitars";quantity). Let's call this field guitarCalc.

You could then use your existing invoice>line items relationship to get Sum(line items::guitarCalc).

Hope that helps.