FM Pro 6 - Repeating field query

[Stig]

I'm working on a database with products file and order file - trying to make scriptmaker take me from one article line in products file to the next line in repeating field on order file. "Go to" commands takes you back to the first line or field - anyone know how to get to the next blank for automatic pasting? ???

[BobWeaver]

You can do it with the "Go To Next field" script command.

The "go to field" command will take you to the first repetition of the field, and then the "go to next field" command will then jump to the next repetition as long as you don't have any other fields arranged in line horizontally with the repeating field. If you do, then you need to make a loop in your script like so:

# Assuming that the name of the repeating field that we are

# stepping through is called "MyRepeatingField"

Loop

[-Queue-]

You can also specify the repetition at the bottom of the dialog where you specify the field, if you want to hard-code it.