Calculation to Find #of certain records

[snatkins]

As part of a script, I need to find the count of # of records with certain code (i.e. Their inventory #s begin with AB or DC or JK, etc...). In the script, the inventory code is stored as a global variable - so that it is recalculated each time it is for a different code. The code field is "Series Initials"

Their is a self-join relationship between the global variable and the Series Initials.

Do I use Count (" ")? - is it: Count (global variable)?

I don't know if this makes sense - any help would be great.

Thanks, Sarah

[snatkins]

I forgot to mention that at the moment, I keep getting the result as 1. And in the script calculcation it is Count (global variable).

[Dan-A]

i think you could get fast results if you had a relationship between

your global code field and a related inventory field.

when you use "go to related record" script step & you specify show only related records you would have your answer with the "Get Found Count".

Only the related records that have AB would show up...

Then change your global for JK and only those would show up etc.

Dan

[Dan-A]

oups, i just noticed you are working with FM 6

i think you can do the same as my previous post but the Get function

is probably a Status function