I've got a whole bunch of records that I need to duplicate and change part of one filed when that happens.

I can write the script to duplicate records, get the loop thing going correctly but have a problem when it comes to changing data in PART of a field.

The Field's current data is 4200-V-NN-TT(where NN and TT are different numbers in each record), and I want to chance it to 8900-V-NN-TT(where NN and TT are the same from the orginal record)

Any help would be GREATLY appreciated....

[ May 30, 2001: Message edited by: Jeffrey T. ]

Hello Jeffrey,

to substitute a portion of your field do this in your script:

- Setfield YourField="8900" & right(YourField,8)

(where 8 represents the fixed right portion of your field "-V-NN-TT")

Obviously in the example i treated "8900" as constant; in your application you can substitute it for a field name which contains the proper data.

Have a nice job & greetings from Holy Lands

[ May 31, 2001: Message edited by: JPaul ]