# of Unique Client Records

[MerlinWannaBe]

In 8.0, I have status records related to client records. There can be many status change records per client. When I do a find on status record types, I'll get several records with duplicate client ID's. Lets say there's 10 records, 2 per client. The number of unique Client ID's would be 5.

Problem: How can I setup a calculation field that will correctly show the # of unique Client ID's in each found set??

Thanks in advance for your HELP!

[-Queue-]

I don't have time to answer this right now, so I'm bumping it for other members to see.

[-Queue-]

So now I do have time.

Attached is an example of what is probably the easiest way that uses very little overhead. It is scripted, with a refresh button necessary unless any operation which can change the found set is scripted, in which case you can call the script as a sub-script from your existing scripts.

There are other methods, some which use only calculations but require the found set to be sorted in order to evaluate properly. They also use much more overhead. So I would recommend a scripted method over any of them.

UniqueValuesInFoundSet.zip

[comment]

Ah, so that was the question. If scripting is the way, then given (a) that the counted values are unique in the parent (Clients) table, and ( version 8, you could also do it like this:

Go to Related Record ["Clients”] [ Show only related records; Match found set; New window ]

Set Field [ Status::gUniqueCount ; Get (FoundCount) ]

Close Window [ Current Window ]

[-Queue-]

That Match found set option kicks butt. Now I wish I had 8.

[MerlinWannaBe]

Many thanks!!!!!

This got me what I needed. The users are very happy now!!

Thanks to you both, comment & queue!!!