Jump to content

copy found set into repeating fields


This topic is 6072 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6072 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.