Going to a portal row for a new saved record

[Chalkster]

I have layouts with a portal on the left and related fields on the right for viewing creating editing and deleting records within the table

There are 3 table occurences involved Zones A, B and C... all are based on the same table i'e Zones

The layout is based on Zones B with a global field relationship to Zones A (Zones::g_ID = Zones B::g_id) . This shows all records in the table in a portal based on Zones A.

Fields used in the layout but not within the portal are from Zones C which is related by the unique value ID field (Zones B::g_ID= Zones C::ID )

This allows me to click on any record in the portal and populate the fields in the layout... so far so good. I also highlight the current record being displayed in the portal

At the request of my users I moved from one layout to four... one each for view, new, edit,delete.

When shifting between layouts from view to others the current portal row remains selected using Get (PortalRowNumber) as a global and setting a calculation to go back to it.

My problem comes when creating a new record..... when it is saved and the user is taken back to the view screen that is the portal row I want to select.... since the p0rtal is sorted alphabetically it is not always going to be in a set position... is there a calculation that can find the row number in the portal for any specific record?

i have a similar problem if a user edits the ID of a zone.... it will move within the portal sort order and my global portal row field will no longer apply... again to find a calculation that will give me a portalRowNumber based on the unique ID field seems to me to be the answer.

Simple highlighting is not the answer because I have many more records listed in the portal than there are rows... so I need to be able to scroll it

I tried a script

Set Field [Zones C::g_ID;Zones C::ID]

Go to Portal Row (First)

Loop

If[Zones A:ID=Zones::g_ID]

Set Field [Zones A::g_portal row number; Get(PortalRowNumber)]

End If

Exit Loop If [Zones A:ID=Zones::g_ID]

Go to Portal Row [Next; Exit after last]

End Loop

Go to Portal Row[no dialg;Zones A::g_portal row]

but it takes a while on a large number of portal records

Does anyone know how to find or calculate a row number within a portal without having a row by row script script it??.... or any other method that would speed up the act of locating a row with a specific value?