July 17, 200421 yr 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.
July 23, 200421 yr Author go to related record will display all of the related records. I want to display only the record the user clicks on.
July 23, 200421 yr 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.
Create an account or sign in to comment