Jump to content

Could someone please explain GTRR?

This topic is 7107 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've been having some problems with some of my more complex scripts, and I've narrowed it down to problems with GTRR (goto related records). Apparently I can't even seen to pull off simple gtrr scripts.

For instance:

Two tables, "gps_assessment" and "significant_others".

The relationship is gps_assessment::screening_id ----- significant_others::screening_id

The relationship name is "gps_TO_sig_others_USING_screening_id"

There are two records related to one of the files in the gps_assessment table.

So on one of my layouts using the gps_assessment table, i created a test script that is just:

Goto related record [show only related records; from table: "gps_to_sig_other_using_screening_id"]

Goto layout ["significant_other" (significant_other)]

The result is that it takes me to the layout, but whatever record was current is showing, none omitted or anything. GTRR was a peice of cake in FM6, I don't think I understand the new theory behind it.

Link to comment
Share on other sites

Reed said:

Get rid of the second go to layout step. Choose the layout from within the GTRR step.

But it only allows me to chose layouts based on my "gps_assessment" table, when I'm trying to see the records from "significant_others"

Link to comment
Share on other sites

The layout you specify must represent records from the table where the related records reside.

The usual use of the GTRR step is to place a portal to the "many" table on a layout for the "one" table. Attach the GTRR step to a button on the portal. GTRR(from "many" table; using a layout for the same table)

Clicking the button will take you to the layout and record specified by the row which was clicked. If you choose "show only related records" then only records shown in the portal will appear in the found set.


Link to comment
Share on other sites

This topic is 7107 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

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