Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Find duplicate records ?

JohnW
in Finding & Searching

Featured Replies

I have FMPro 4.1 on my office PC that runs a simple single file/single screen DB. Due to some file merging I have some number of duplicate records. Each record has a "work order" number. I want to have a search that finds all the duplicates so I can kill the older version. How is that done ?

JohnW

Change into find mode. On the status bar there is a pop-down list or menu with symbols: select ! to search for duplicates.

Note that this finds all duplicates -- that is, if two records have the same value it finds *both* of them. So don't delete them all, scroll through and delete the extras.

  • Author

Thanks, I'll give that a try .

JohnW

  • 1 month later...

Is there a script command for the "!" function?

-a

Enter Find Mode [no restore]

Set field [theField, "!"]

Perform Find [no restore]

Create an account or sign in to comment

https://fmforums.com/topic/376-find-duplicate-records/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.