How to find Distinct values

[pkudrle]

Well I searched and searched and could not find any posts about this.

I want to do a search and return only unique values, even if there are duplicates.

I know how to do this in SQL, but how do I transfer that to Filemaker.

SELECT distinct column_name

FROM table_name

Thanks,

Paul

[CyborgSam]

Check out ColbaltSky's web site: http://www.nightwing.com.au/FileMaker/demos5.html, look for Finding only one of each record when there are duplicates!

Here's the blurb:

Omitting duplicate records is something that is frequently required, but the best known technique involves a script which marks records then omits them - and that can produce unpredictable results in multi-user mode (eg if more than one user is running the script at once).

This sample technique file shows a method by which duplicate (second or subsequent) copies of a record can be omitted by script without any record marking, based on the contents of a field. In the demo implementation, the field which will be checked for duplicates can be selected. Of course - with the addition of a couple of steps - the demonstrated technique can also be used to locate and remove any duplicate entries!

Version: v7.x

Platform: Mac OS X Panther