Related record from a portal

[Yiannis]

Sorry about my English. If you can not understand me forgive me...

Please I want to find a solution to my problem and I can't.

My problem is that I have a file with name "Room Reservations" and another file

with name "Plan of rooms" with a related portal from a third file with name "tempfile". I use the temp file to hold all the reservations for a room using "RoomId" match field so the portal in the "Plan of rooms" can appear all

the reservations for each room. The real problem is that because I have a relation between "Plan of rooms" and "Temp" files I can not use the portal fields If I click them to go to a related record in the "Room Reservations" file. How can I make the portal to be related with both files?

[Ugo DI LUCA]

You can set a multiple go to related records. That is that the first step of your script will lead to File B and then a sub-script would lead to file C.

Look at Kevin Franck for a good Demo and explanations of the concept

Kevin Franck Multiple GTRR

[Yiannis]

The Kevin's Frank paradigm is Ok but it isn't refered to a portal situation. Do you have any other idea?

I repeat that the problem is how can I go to a related record in the master file from a portal in a second file when portal doesn't have a relationship with the master file but with a third temp file.

Thank's for your support.

[Ugo DI LUCA]

Here is an attachment I made for you to understand. Very simple DB with Invoices, Line Item and Product File.

The portal in Invoices is related to the Line Item, but you can trigger a scipt to go to the Product File.

[Yiannis]

Thanks in advanced Ugo! I will try it...

[Yiannis]

Yes It working.

It was so simple...

Forgive me I just came from MS Access and Vba after a long

period of masochism with those products and I can not find

yet my rythm with the thinking of FM scripts.