Loop thru Multivalued field

[Andrew_Hobson]

Hello,

Is it possible to make a loop with scriptmaker that goes thru each records of a Multivalued field?

Or must I address each Multivalued field individually?

If it is possible can someone point me to an example?

Thanks for the help.

Andrew

[Lee Smith]

What is it that you are trying to do, what is your desired result?

Lee

[Andrew_Hobson]

I need to go thru my selected records, and go thru each Multivalued fields and

if the record matches some croteria, I need to create a record in another table (that is not linked).

I want to avoid to write in my main loop (in sort of pseudo code)

Loop thru record of Table A

if (Multivalued 1 = Yes)

create record Table Z

end if

if (Multivalued 2 = Yes)

create record Table Z

end if

if (Multivalued 3 = Yes)

create record Table Z

end if

if (Multivalued 4 = Yes)

create record Table Z

end if

End Loop

I would want to write:

TheMax = Get the max possible records in a Multivalued field

Loop thru Table A

for Counter from 1 to TheMax

if (Multivalued (Counter) = yes)

create record Table Z

end if

end for

End Loop

I'm a replying to your question?