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.

Finding Duplicates using !

  •
MikeTheDataGuy
in Finding & Searching

Featured Replies

  • Newbies

Hi.

If I use ! in the Find Mode, will this find all of the duplicate records in my table?

If so, can I delete the "found" duplicate records in order to have a clean, no duplicate database?

Thanks

No because this will delete your originals as well. You can either do an advanced search for +delete +duplicates or you can follow the method in FileMaker's help files.

  • Author
  • Newbies

How do you do that advance search that you mentioned.

I'm trying to delete all dups from the database without deleting the originals.

Mr Vodka was suggesting that you search the Forums using the term "+delete +duplicates" to find other posts that may help, or search FMP help for their suggested method.

  • 2 weeks later...
  • Author
  • Newbies

I'm having problems finding any topics on finding and removing duplicates without deleting the original record in FMP9.

Can anyone copy and paste instructions?

Thanks

Mike

Some detailed instructions are in this TechInfo article:

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=3441

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

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.