Could someone please explain GTRR?

[ddreese]

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.

[Reed]

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

[ddreese]

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"

[Reed]

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.

Dana

[ddreese]

Thank you, the new relationship-model confuses me a lot... it's espeically difficult to keep them straight on that graph! Turns out I was missing a key relationship. Thanks for your help!