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 by relationship not working as in FM5

Featured Replies

My plan is to have the user view a list layout showing various reports and their contents and other significant data. Some reports have similar types of data from different dates and comparing that data is important. One of the buttons in the header is "Same Client & Report" which would (using setfield) copy the client ID and Report items fields into corresponding globals and the command show related records. The result would be a list of all records having same item and client id as the initial report viewed. This worked great in FM5 but not FM7. What am I doing wrong.

Find would not work because reports can have multiple topics A,B or B,C, or A,D. If my initial report is A,B than I want to list all reports containing either A or B. a relationship is the perfect tool as using the paragraph mark between topics gets the appropriate result. I don't want to build a portal and make it look like my list layout if I don't have to.

My table is Reports. My fields are ClientID, Topic (which is states what the report contains in 1 or 2 standardized words, and if more than one topic is present in the report the topics listed will be separated by a paragraph mark), gID a global field, and gTopic which is another global field.

My relationship ReportsByTopic is ClientID to gID and Topic to gTopic.

The layout is formated to reports.

My script is

Setfield gID: ClientID,

Set field gTopic; Topic

Show related records ReportsByTopic using current layout

I miss the intuitiveness of FM5 but the features of FM7 are can't be beat.

Any help is appreciated, as always.

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.