I'm prepping a FM 7 customer database for export to MySQL. I've created a password field and want to assign a temporary password for each record. I'd like to assign something like password1, password2, password3, etc, to each successive record. I can't figure out how to set up a script to keep the field text constant while adding a number incrementally.

Try the SerialIncrement ( ) function.

I thought that SerialIncrement would do what I wanted but it's assigning every record the same result. It's not assigning incrementally.

Here's what I've set up. Does anyone know what I'm doing wrong?

Go to Record/Request/Page [First]

Loop

Set Field [CustContacts::Password; SerialIncrement ("password1"; 1)]

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

End Loop

Use the Replace script step and specify it to enter a serial number "password1" incrementing by 1.

Thanks for the tip. That worked perfectly.

SerialIncrement ( "password" ; Get (RecordNumber) ) would have worked.