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 records with one field = another field

Featured Replies

Is there a way to find records where one field in the records equals another field in the record? The matching values will likely be different from one record to another.

Yes, there are many ways...

for example you can create a new calculation field with this calc:

field1 = field2

and search for records that have 1 inside that calc field.

  • Author

For a fixed pair of fields, you're right of course. But is there a general way to do this with any pair of fields using Ctrl/F?

I don't think so, but you can make the calculation more flexible, e.g.

GetField ( gFieldName1 ) = GetField ( gFieldName2 )

Of course, this needs to be unstored, so the find may take a bit longer.

Create an account or sign in to comment

Important Information

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

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.