Go To Portal Record

[johncrane]

I have always used the following technique to jump to the related file from a portal record.

In the Portal is a hidden field that is the serial number of the portal record.

Serial Numbers are automatically assigned.

There is a button in each portal line so that it selects the portal row and does the following Script:

Enter Browse Mode

Copy Serial Number

Perform External Script in the Related File

The script in the Related file is as follows

Go To Layout that has the serial number in the layout

Enter Find Mode(No Options Checked)

Paste Serial Number

Perform Find(No Options Checked)

In all of my development I have used this technique in all of the databases that have portals. It has works with no problems.

I have one database that it refused to work. It would always go to the first record that was shown in the portal when coping the serial number.

The only way I could make it work was with the following script in the database with the portal:

Set Field Global3, Status(CurrentPortalRow)

Go To Portal Row Global3

Go To Field Serial Number(Select)

Copy Serial Number

Perform External Script in the Related File(This is the same script that I used before.

I have got to be doing something wrong with the relationship or the portal but I have checked it with all of the other scripts that I used the same technique and can find nothing different in the scrips, layouts or relationships.

Has anyone run across this problem. It is driving me nuts. Any ideas would be appreciated.

[-Queue-]

Hmm. Why not just use Go to Related Record [show only related, yourrelationship]?

[johncrane]

go to related record will display all of the related records. I want to display only the record the user clicks on.

[RalphL]

Go to related record (show) limits the found set to the related records and goes to the first record in that set. Go to related record goes to the related record but does not change the found set.