April 4, 200520 yr 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?
Create an account or sign in to comment