Skip 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 duplicate records from two files.

Featured Replies

I have two files [Contacts] and [New Data]. Both files contain the same basic information and are both FM 5.5 files.

What I want to do is import the information from the [New Data] file into the [Contacts] file and delete the duplications by Phone Number.

Thanks for your help...

First make copies of both files, and then work with the copies.

Next, do an import in the reverse direction from Contacts into New Data, using the update existing records option. Use the phone number as the match field in each file, (the symbol between each field will be <=>, not =>), and don't select any other fields for import. What this does is find the set of records in the New Data file that are duplicates of records in the Contacts file. Now, do a "Show Omitted" which reverses the found set to the non-duplicates.

Finally, you can import the non-duplicates into the Contacts file, because only the current found set in New Data will import.

  • Author

Bob,

Thanks for getting back to me. I

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.