Jump to content

GoToRelatedRecor? HELP???


This topic is 8578 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

  • Newbies

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 frown.gif

Link to comment
Share on other sites

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
frown.gif

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

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

This topic is 8578 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.