export all records to 1 text field?

[stann]

Hello

I would like to export a bunch of Vin numbers ( now in different records in a field called "vin") to one field with paragraph returns ( called "vinNumbers" . How is this done? I appreciate your help with this.

Thanks

STan

[RalphL]

2 ways:

Make a value list of Vin numbers using the data in the other file. Make a calculated field = ValueListItems ( current file; Value List)

Use the Troi Text Plug-in.

[andygaunt]

Or you can script it.

Create a layout with just the Vin number field on. you will also need to know where you want to place the return seperated list (which field and a layout that field exists on)

Then in your script

Go To Layout [one just created]

Copy All Records

Go To Layout [a layout with the field on you want to paste the list]

Paste [select the correct field]

[Lee Smith]

Hi Stann,

I use Andy's approach all of the time to copy several fields, only I don't paste it into a field, I just paste it directly to my text document. FileMaker will add a Tab between fields, and a return between records.

HTH

Lee