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.

Lookups from a separate FM7 file

Featured Replies

  • Newbies

FM6 was no trouble, but how do I perform a look up from one FM7 file to another completely separate FM7 file (not tables within a FM7 file)? I have a "telephone log" FM7 File and a "project file" in FM7. From the "telephone log" file I want to look up and copy over from the separate "project" file the project number, description, etc.

Add a File Reference to the external file (File->Define->File References), then you can choose a table from the external file as the source of the lookup. If you have large tables, I'd recommend using an auto-enter calc instead of an auto-enter lookup, as those lookups perform significantly slower in FM7/8 than an equivenant auto-enter calc.

  • Author
  • Newbies

Thanks for the tip. The manuals do have information on File References, but any reference to Lookups simply refers one to the method of using Tables in the same file. Now I will work on Auto-Calc. Doesn't seem to be intuitive.

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.