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.

Compare two different fields from two tables

Featured Replies

  • Newbies

I'm trying to get file maker pro to compare two fields from two different tables to result in true/false. A screen shot of what I have is below. For some reason, I can't get the values in the honoree:hon_lastname to result in a true result when the potentials:po_surname is the exact same. Can anyone help?

script.jpg

1) Insert Calculated Result requires that the target field be present on the layout to paste successfully. If no field is active when the script is performed, the step has no effect. Does po_match exist on your Potentials Honoree_Entry1 layout?

2) What is your match field between Potentials and Honoree? Whenever I see Insert Calculated Result setting a field with 'ID' in it, I get suspicious of the relationship.

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.