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.

Check box across 2 files

Kristen
in Value Lists

Featured Replies

I have 2 related files: donor.fp5 and vendor.fp5

vendor contains a check box field with Yes or No as the options, and another field company name. Donor has a field: Non-Profit, which is a drop down from CompanyName in vendor. I want to be able to do a find in donor for all the Non-Profits that have the check box marked YES in vendor. I will eventually be performing a script from donor.fp5 with these records, so if I can script the requests that I want that would be good also. I am sure this can be done with the creation of some "holder" fields of sorts, but I am stumped. Any thoughts???

As you may also want to do the reverse, add

- one globalYN (text) in Donor and attach to it a value list "Yes/No".

- one calculation c_LeftKey = NonProfit&" "&globalYN

Then, in Vendor a calculation c_RightKey = CompanyName&" "&checkboxYN

Establish a relationship between the c_LeftKey and c_RightKey and see the result in a portal or trigger a GTRR.

Of course, if you could have a key rather than a name, this would be safer.

Create an account or sign in to comment

https://fmforums.com/topic/20059-check-box-across-2-files/
Go to topic listing

Important Information

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

I accept

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.