Look ups in Repeating fields

[stac_1]

Hello,

I have 2 repeating fields that repeat 4 times each and the one repeating field needs to look up data for each different repeating line item from a related record (based on the critera from the first repeating record). The only way I can get the whole repeating field to look up for all 4 lines is to script a "relook up" - which works like a charm but gets very time consuming as well as "relooks up" every field for every record in the database. Is there a way to have the repeating field look up each line in the repeating field without having to use the "relook up" option? (I have tried using a calculation but it only looks up for the first line in the repeating field)

[LiveOak]

I gave up building on my stock of repeating field tricks with the advent of FM 3.0 in 1996. Why not convert the repeating fields to multiple, non-repeating fields? You can see how popular pushing the envelope of repeating fields is by the number of responses to your post .

-bd

[stac_1]

I can believe that.... but, if I were to convert these repeating field as you suggest, wouldn't performing a find be a bit of a headache? ;-) - or is there an easy way to do that?