Enetering data into Multiple Records

[Steve Faulkner]

I would like to enter the results of a "Insert Calculated Result" into a field in all records. In the script I have made it only calculates in the first record. What instruction do I need to enter the data in all the records.

Many Thanks

Steve

[transpower]

Loop through all the records in the script.

OR, from FM Help:

To replace field values in every record in the found set:

1. If necessary, find, omit, or sort the records in the database file.

For more information, see Finding, sorting, and replacing data.

2. In Browse mode, in the current record, select the contents of the field you want to replace.

3. If you're replacing data with a constant value (instead of serialized numbers or a calculated result), type the value.

4. Choose Records menu > Replace Field Contents.

5. In the Replace Contents dialog box, select an option:

To replace each value with

Select

The value in the currently selected field

Replace with <value>. FileMaker Pro replaces the contents of the field for the entire found set.

A serialized number

Replace with serial numbers, then type the starting value for the serial numbers in Initial value, and the incremental value in Increment by.

If the field is defined to automatically enter a serial number, you can select Update serial number in Entry Options to reset the next value in the Options for Field dialog box.

A calculated value

Replace with calculated result, then click Specify. In the Specify Calculation dialog box, enter the calculation you want evaluated. (The result must match the field type of the replaced field.) Click OK.

Fore more information about the Specify Calculation dialog box, see Defining calculation fields.

6. Click Replace.

[Steve Faulkner]

How do I loop all records in the script ??

Thanks Steve

[-Queue-]

Go to Record/Request/Page [First]

Loop

{Do something}

Go to Record/Request/Page [Exit after last; Next]

End Loop