I am trying to to click data in a field and have the program automatically find all the records with the same data. Example: I have course numbers in a field called courses for every record. 123, 123, 127, 128, 129, 123, 123, 127, etc. I want to click on 123 in one record and have FM return all the records with 123 in the course field. I figure I have to create a script and attach the script with a button on the field.

Any help will be appreciated.

Thanks

I am using FMP 6 on a PC

A standard Find with "!" (no quotes) in the field will find duplicates.

I know I can find by typing in an ! to find duplicates. I what to click on the field on s specific number and have all the numbers that are the same come up on the screen. Like clicking on a button with the number and FMP finds them for me without asking for a manual CTL FIND

Try:

Set Field [ gValue, CourseNumber ]

Enter Find Mode

Set Field [ CourseNumber, gValue ]

Perform Find [ Replace Found Set ]

where gValue is a global field of the same type as the CourseNumber field.