Input value from 1 field and navigate to layout

[corey]

Senario.

I have a main layout.

It has various fields, 1 (one)of which has a repeating number field(7)[NAME].

Layouts 2 through to 8 are basically 1-8 paged duplicate layouts with a few common fields.

Reason.

If there is an entry in some of the repeating[NAME] fields, then i want to create a script to navigate to a corresponding layout. But i want the value(if any) from the [NAME] field/s entered into the other layout fields.

Why.

In the main layout i have the repeating field that may or may not have any values placed in them.

It can have values in any or all of the fields, but not necessarily in each adjacent field repetition.

If there is say 3 values out of the 7 fields entered (say rep 2,4,and 7) then i want to hit a script to print the main layout, then depending on the amount of values out of the possible 7 repeating fields, navigate to a layout with the correct amount of pages (which are layouts 2-8) (this instance is 3)AND (here's the senario needed)to input the values into this layouts fields.

In the above example there would be 3 values, therefore navigation is taken to a layout that has 3 pages, each with a field where each value from the main layout would be automatically placed.

Hope i explained this OK.

Any ideas how i can achieve this?

Corey....

[comment]

The navigation part is easy:

- arrange your layouts in ascending order of pages;

- define a calculation field =

n + Count (repeatingField)

where n is the position of the single-page layout, minus one;

- in your script, go to layout (layout number from field)

The conditional setting of individual fields to values scattered in repetitions is another matter. I don't see how this can be accomplished other than by a complex script, explicitly covering every possible combination.

I believe it would be better to use a related file, where you can print each record on its own page. Instead of repeating field, you would have a portal, so the values would already be where you need them when you go to print.