AnsweredAssumed Answered

Filemaker equivelent of SQL Select Distinct

Question asked by RestaurantCharlie on Apr 19, 2011
Latest reply on Apr 20, 2011 by LaRetta_1


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.