Newbies Night_owl Posted October 2, 2000 Newbies Share Posted October 2, 2000 Hi! i have 2 files. From first file i use GoToRelatedRecord[showOnlyRelated] to go to the related records int he second file. HOW DO I LOOP thought ALL related records ONE BY ONE ( in order lets say to add up the total price ):? Is there a way to do so only from file two?? or do i need to have a script in file one ( that goes goToNextRecord ): The reason i need the script to run in the second file - is to keep the database as flexible as possible. Plz help. Link to comment Share on other sites More sharing options...
Kurt Knippel Posted October 2, 2000 Share Posted October 2, 2000 quote: Originally posted by Night_owl: Hi! i have 2 files. From first file i use GoToRelatedRecord[showOnlyRelated] to go to the related records int he second file. HOW DO I LOOP thought ALL related records ONE BY ONE ( in order lets say to add up the total price ):? Is there a way to do so only from file two?? or do i need to have a script in file one ( that goes goToNextRecord ): After using the GTRR script step then you just need to run a script in your related file. There are Loop script steps, using the Go To Record[Next] script steps. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Newbies Night_owl Posted October 2, 2000 Author Newbies Share Posted October 2, 2000 so there is no way i can loop thought the record in second file by just using the sctip in the first file? i've tried open[file2] loop go to record [next,exit after last record] end loop and that dont work ither i ran this from within file1 Link to comment Share on other sites More sharing options...
Chuck Posted October 2, 2000 Share Posted October 2, 2000 quote: Originally posted by Night_owl: so there is no way i can loop thought the record in second file by just using the sctip in the first file? i've tried open[file2] loop go to record [next,exit after last record] end loop and that dont work ither i ran this from within file1 You could put a portal to the second file in a layout in the first file and then loop through the portal rows. Chuck Link to comment Share on other sites More sharing options...
Newbies Night_owl Posted October 3, 2000 Author Newbies Share Posted October 3, 2000 how do i loop thought a portal?: Link to comment Share on other sites More sharing options...
Chuck Posted October 3, 2000 Share Posted October 3, 2000 quote: Originally posted by Night_owl: how do i loop thought a portal?: If there's only one portal on the layout: Go to Portal Row [ First ] Loop do what you need to for the row Go to Portal Row [ Next, Exit after last ] End Loop If there's more than one portal on the layout: Go to Field [ (a related field in the portal you want to go to ) ] Go to Portal Row [ First ] Loop do what you need to for the row Go to Portal Row [ Next, Exit after last ] End Loop Chuck Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8207 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now