Jump to content

How to find Distinct values


This topic is 6721 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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



Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6721 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.