Portal to portal

[miltont]

Hi All,

I have a layout that holds 2 portal, which are both based on the same table.

The portal on the left holds one record (actually a note for a staff member) and the portal on the right shows a list of the notes with a description and the author of the note along with created and modified date. There may be several hundred notes and what I want to acheive is the user scrolls through the records in the right hand portal and once they get to the note they want to view they click a button that I have placed on each row on the right hand portal so that the note in the left hand portal jumps to that portal row but I cannot figure how to write a script to go to that particular portal row.

On the same theme, I have a button on the left hand portal to print this particular note but it always only prints the first note on the layout called Staff Print Note and not the one that is currently showing. Can I make the Staff Print Note layout be based on a portal row and not a table?

Any help would be greatly appreciated.

Milton.

[comment]

Make the button in the right hand portal set a global field to the ID of the selected note. Use this field as the matchfield for the second relationship. You don't need a second portal: just place the fields from the second relationship directly on your layout.