AnsweredAssumed Answered

Produce List of UniqueIDs in found set.

Question asked by RestaurantCharlie on May 10, 2011
Latest reply on May 10, 2011 by philmodjunk


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.