copy found set into repeating fields

[Donnie]

I’d like to copy the field contents of a found set of records from Table A into one repeating field in Table B. Is there a scriptable way of accomplishing this task without the use of a text editor and lots of manual steps as described in the FMP Knowledge base?

Example: Table A: 10 records in the found set – copy the Client Numbers from these 10 records into a repeating field of ONE record in Table B. There is no relationship between Table A and Table B.

[Søren Dyhr]

There is no relationship between Table A and Table B

Why not?? When it's the clientnumbers can't it be an attempt to drill sliding objects as here:

http://fmcollective.com/2007/08/29/pseudoportals-with-alternating-fill/

Are you sure the skill level you give, isn't your excel skills instead. Your question seems like - first pitthole to fall in, the dangerous fling with repeating fields... well with 40 posts should you have learned by now that they live a slight of stigmatized existens unless they're going to be use for utility purposes, such as relational keying, when simple ranges can't give the virtue desired. But the need to gather UserID in a repeating field, which have the exact similar virtues as a pilcrowdelimited text field if the use is a relational key ... why jump the hoops of getting them into a repeater.... when a relation and:

http://www.filemaker.com/help/Functions%20Ref4.html

Gives you this key-virtue???

--sd

[bruceR]

I’d like to copy the field contents of a found set of records from Table A into one repeating field in Table B.

This is a waste of time. Get rid of the repeating fields and use a related table.

[Søren Dyhr]

Thanks Bruce for taking a turn in this sisyphean task! ...are we being drilled in this:

True wisdom knows

it must comprise

some nonsense

as a compromise,

lest fools shouls fail

to find it wise.

...or do we forget to exercise it, properly??

--sd