Hi,

I'm using FM 7, and I need to do a match import/add remaining where
the target file match field is a repeating field.

This is for a 1-many rlship, and the match field is a repeating field
with a bunch of id numbers.

I want to match any of ID numbers in the FM repeating field with the
ID value in source data.

But the match seems to only find the first value in the field, and
then creates new records for any additional IDs.

Any ideas or work-arounds?

Thanks!
msly

Repeating fields doesn't work as keyfields on foreing keys, turn the
field into a return delimited textfield instead ...in your case is the
quickest fix probably to repoint the relation to a calcfield stacking
the adequate number of GetRepetition('s.

Nowadays doesn't repeating fields have much use, since the upper limit
a field can hold if it's going to be a multiline relations key (not
foreign), which previously was 64K - now with ver. 7 have become
history.

--sd

me@mattsly.com (msly) wrote in message news:<ea3fe397.0406070915.5b322c86@posting.google.com>...
> Hi,
> 
> I'm using FM 7, and I need to do a match import/add remaining where
> the target file match field is a repeating field.
> 
> This is for a 1-many rlship, and the match field is a repeating field
> with a bunch of id numbers.
> 
> I want to match any of ID numbers in the FM repeating field with the
> ID value in source data.
> 
> But the match seems to only find the first value in the field, and
> then creates new records for any additional IDs.
> 
> Any ideas or work-arounds?
> 
> Thanks!
> msly