Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

copy found set into repeating fields

Featured Replies

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.

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

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.

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

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.