Produce List of UniqueIDs in found set.
I'm looking for a function that can do the equivalent of SQL's Select Distinct.
For example, I have a table with SalesLineItems. If I want to produce a summary table for sales by product for a given week. In SQL I would start from selecting the distinct Part IDs where date range is between A and B and then joining the sum of qty. I might want to store the return separated list as a variable of global field and then work from there.
This is only one of the things I want to use it for, and while there might be a better way to achieve this in filemaker (input appreciated), I really want to know how to produce the equivalent of Select Distinct.