250 records into one field

[mcbain1212]

I have a database of 10,00 widgets. I am tiring to get field (widget name) of 250 records into a single field containing all 250 entries for field widget name. I

[Vaughan]

Make a new layout with just one field on it, widget name. Change to this layout, find all records. Now hold the Option key down (you are on a MAc right) and choose Copy from the edit menu (it may say Copy All records).

All the widget names are on the clipboard, paragraph delimited.

Remember that FMP 6 and earlier has a 64KB text field limit. The combined widget names of 10,000 records may exceed this limit.

[mcbain1212]

"Change to this layout, find all records. Now hold the Option key down (you are on a MAc right) and choose Copy from the edit menu (it may say Copy All records)"

First of all thanks for the post. I have two questions:

1. how do I find all records? In a script, show all records?? I am new at this.

2. I need to take the first 250 and put them into a field then the next 250, and so on until I have reached 10,000 record. So copy all records wont work for this.

I have been messing with useing omit and count functions in a script to somehow count 250 records and then copy them and then omit them from the list or delete them. I can see the logic but do not know how to set up the actual script. I have been trying to get it to work this way but my scripting is very basic and does not work. Any help would be great.

[-Queue-]

Show All Records

Set Field [globalfield1, ""]

Set Field [globalfield2, ""]

Set Field [globalfield3, ""]

...

Set Field [globalfield40, ""]

Go to Record/Request/Page [First]

Go to Layout [{containing only widget name}]

Copy All Records

Go to Layout [{containing globalfield1}]

Paste [globalfield1]

If [status(CurrentFoundCount) < 251]

Perform Script [Copy globals to fields]

Exit Script

End If

Omit Multiple [250]

Go to Layout [{containing only widget name}]

Copy All Records

Go to Layout [{containing globalfield2}]

Paste [globalfield2]

If [status(CurrentFoundCount) < 251]

Perform Script [Copy globals to fields]

Exit Script

End If

Omit Multiple [250]

etc.

Repeating the pattern 40 times. You can put the globals on a single layout and loop through them using

Exit Record/Request

Loop

Go to Next Field

Set Field [ , ""]

Exit Loop If [status(CurrentFieldName) = "globalfield40"]

End Loop

Or use a single global with 40 repetitions and do something similar, exiting the loop when Status(CurrentRepetition) = 40.

The 'Copy globals to fields' script would Show All Records and go to the record where you want to store the data, then Set Field [field1, globalfield1], etc.