You can try this manually first to find out what happens. Best is to do this in a table view layout so you can clearly see what happens.
First you perform your find. Like you did.
- Enter Find Mode [Uncheck Pause]
- Set Field
- Perform Find
Then the trick is to make sure your sorting is not going to unintendedly move records around so:
- Unsort records
- Go to Record Request [First]
- Duplicate record
This makes a duplicate and puts that duplicated record at the back of your found set.
- Set Field to change whatever value you want to change in that duplicated record
- Omit record. (To remove that record from the found set)
- Go To Record / Reuest [First]
- Omit Record ( To remove the one you already duplicated from your found set)
- Exit Loop if [ Get (FoundCount ) = 0]
This is just of the top of my head, so might need some tweaking.
I just realised that the script had not yet created the new master record which supplies the default value for the new duplicated record's find criteria.
I'll do the mods, test and update this post soon.
My thoughts of "master record" were not relevant anyway.
Your "omit" method worked a treat. Nice and simple.