select distinct

[Curtis_B]

I'm hoping to do the sql equivalent of 'select distinct' in a filemaker find. I'm in version 7. I know I could write a script to give me distinct values, but I would hope this is a built in function. The manual makes no mention of such functionality. Thanks

[jscooper]

It depends on how you'll use the values. If they're for a report, you can use subsummaries to show distinct values. If you need a list of values in a form, you can define a value list showing the field you need then use ValueListItems() to display it. Or, if you actually want to find only one record ("copy") of each value then you still have to use a script to do it.

I too yearn for some sort of simpler Select Distinct... capability.

Jeff