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.

Lookup Between Layouts & Tables

nightowl
in Relationships

Featured Replies

  • Newbies

So I have been on a crash course with FM and have finally hit a bump in the road I'm unable to solve.

Scenario:

I have two tables with an ID field and relationships are established.

What I would like is that when the fax button is clicked which opens another layout to the fax table i would like the ID to be carried over from the record that was being viewed in the other layout and table.

What I currently have been doing is running a script that is in a drop down list to populate the ID and person’s name, meaning I have to select from the drop down and then the info is carried over. I'm looking to automate this with the above statement. Attached is a link to the file if I wasn't to clear.

http://www.nightowlpcs.com/webdb.fp7

Pretty much go to the individual's record and click fax and the drop down list is there. :)

Thanks

i would like the ID to be carried over from the record that was being viewed

Use either a script parameter or a script variable.

  • Author
  • Newbies

Use either a script parameter or a script variable.

Is there a certain one that you would recommend? I'm trying to keep this easy as possible.

I'm not very fluent in FM scripting.

Thanks,

Is there a certain one that you would recommend?

No. And you should get familiar with both in any case.

  • 2 weeks later...
  • Author
  • Newbies

No. And you should get familiar with both in any case.

Know of any examples that would pertain to what I'm trying to accomplish?

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.