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.

Find Unique Field Values and Delete All Others

tbfilemaker
in Script Workspace and Script Triggers

Featured Replies

My database has several records with duplicate values for one field. I need to find the unique value for that one field and Delete All others.

Example: I have a PO # 1234 for Record #1, PO # 1234 for Record #2 and PO # 1234 for Record #3. My goal is to find PO # 1234 and Delete All the other PO # 1234s. The catch: I have several different PO #s that are duplicates, ultimately I need to get one unique set of PO #s.

Any tips or pointers would be greatly appreciated, thanks in advance.

There are a number of posts about this topic. And most notably the basic script example given in the Filemaker User manual covers this exact situation. Look at the script example at the end of chapter 10.

  • Author

Thank you kindly.

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

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.