View record detail of selected portal row

November 23, 200718 yr

I am trying to write a script whereby clicking on a portal row displays selects the correct portal row and displays only the for the corresponding record in another layout.

Have to admit I'm beaten on this one at the moment.

I've been thinking on these lines:

Copy [select; Related.Table::Field( Get ( PortalRowNumber ))]

Go to Layout

Enter Find Mode

Corresponding Field in related table

The Get(PortalRowNumber) displays a dialog which shows the correct portal row is selected, but nothing seems to be copied or pasted.

Any ideas please?

FMP9 on MacOS X 10.5

Edited November 23, 200718 yr by Guest

November 23, 200718 yr

Hi Craig

You are making this a lot more complicated than it needs be. Just use the 'go to related record' script step and you will be given the option to nominate which layout you want to display the related information in and hey presto!That will give you what you want.

HTH

Phil

November 23, 200718 yr

Author

Thanks for that. Wow!

However, I am not given the option to choose the layout I want as it does not appear.

Is there some criteria determining which layouts can be used?

I've changed the name of layout from when first setup to be something more friendly, from 'related.table' to 'Meaning Name'.

Cheers

November 24, 200718 yr

If the layout you want does not show, then you'd best look over your relational structure. FileMaker only shows layouts that can show the data which is in the table belonging to the table occurrence (TO) of the portal. If you need to go further down/up the relational line you can do so using a script, using a 2-step method.

1. Go To Related Record [ portal's relationship; portal TO's table layout ]

Now you're on a portal table's layout*

2. Go To Related Record [ portal table's TO to another TO; the layout you wanted, of a different table ]

*Because you can "jump" to a different Table Occurrence Group, unconnected to the original TO, during a Go To Related Record step, the 2nd jump could go to a table occurrence that is not even connected to the portal's TO. This would sometimes be the case if you use the Anchor-buoy method for your Relationship Graph and layouts. Either or both 1 and 2 above could jump TOGs.

In other words, it is the "table" that determines what is shown for layout choices, not just the table occurrence. Hard to explain in words (apparently -).