Copy All Records

[Ocean West]

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.

[BobWeaver]

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)