Jump to content

Copy All Records


Ocean West
 Share

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

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.

Link to comment
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)

Link to comment
Share on other sites

This topic is 7354 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
 Share

  • Who Viewed the Topic

    2 members have viewed this topic:
    ericire  DPaquin 
×
×
  • Create New...

Important Information

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