Loopy Loops

[scg198]

I have two protals Portal 1 and portal 2 linked to a file. In portal 1 I have the values a, b, c, d and in portal 2 I have the values 1, 2, 3, 4 I need to combine these portals in another file so that I will have a 1, b 1, c 1, d 1, a 2, b 2, c 2, d 2,.....

I cannot hink of a way to both sources of data for this.

In the main display I have a job number which allows me to link the 2 files. Can anyone help my brain is now fried with attempts.

Simon

[LiveOak]

What you need here is a looping script with two nested loops.

# Set row counter 1 to first row

# Set row counter 2 to first row

Loop

# Select a row in portal 1

Loop

# Select a row in portal 2

# Combine values and write a record to third file

# Exit Loop if last row

# Set row counter(2) to row counter(2) + 1

End Loop

# Exit Loop if last row

# Set row couner(1) to row counter(1) + 1

End Loop

You could also do this using the found sets in the two files and skip the need to be on the layout with two portals for the script to work. You will have to use a Go to field step before the Go to portal row step to tell FM which portal you mean.

-bd