Filemaker equivelent of SQL Select Distinct
The solution I need can be asked with the problem from this scenario:
I have a table with sales, and in that table there is a PART field. Sales for a given day have hundreds of records, but under one hundred parts. What is the fastest or best way to produce a list of the parts that are in the given found set.
Up until now I have used a script that sorts by part and loops through them adding to a return separated list every new value it encounters in the part field. I can then take that list and place it in a separate table of field.
In SQL this is very easy, I would do: Select distinct Part from Sales.