Jump to content
Sign in to follow this  
Ocean West

Copy All Records

Recommended Posts

Ya know the trick where you put a single field on a layout then in a script do a "Copy All Records" then paste that in a global then goto related records?

You can save a layout and the copy & pasting, by setting up a relationship to the file you are in locally. To first find all like data. Then set a global field using the design function.

ValueListItems("FileName.fp5", "ValueListItem")

Make sure the global is a text. It will result in a return seperated list.

Share this post

Link to post
Share on other sites

This is very close to the agregate concatenate function that I've been looking for for a long time. Great idea!

Here's a neat little addition. If the value list is set up as a "use related values only" type, using "Keyfield" as the related field, then you can have the field contents instantly update with the set of related values using the following calculation:

ValueListItems("FileName.fp5", "ValueListItem")&Left(Keyfield,0)

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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