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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

find records on related table

Followers

August 18, 200916 yr

Newbies

Hi everyone.

I have a simple problem I'm not able to solve, due to my lack of experience...

I have a layout showing the records of a table, called ITEMS.

This table is related to another table called COMMENTS, through a field called ItemID on both the tables.

What i'm trying to do is browse the ITEMS layout, and find the item I'm interested to. Once there, with a button and a script, I wish the program to open the COMMENTS layout, showing only the comments related to the ITEMS record shown when I pushed the button.

Not so difficult, is it? But I lost the way with parameters, variables, global fields and so forth.

The result I got is this:

pushing the button on ITEMS layout, the program goes to COMMENTS layout, but doesn't find any record (I charged some sample records, so I'm sure, once the mistakes will be fixed, the program MUST find some records).

Thanks for help