Help me write scripts

[MadHatter]

I have to have a script that will take certain characeters from one field and paste them in another.. for example the record would look like this

----------------------

First Name: John

Last Name: Doe

Record Number: 26

User ID:

----------------------

and i would like to have a script that will look at the first name and take the first letter and paste it in the userid field..

----------------------

First Name: John

Last Name: Doe

Record Number: 26

User ID: J

----------------------

then look at the secondname and take the first letter and put it in the userid field

----------------------

First Name: John

Last Name: Doe

Record Number: 26

User ID: JD

----------------------

then take the record number and copy it into the userid

----------------------

First Name: John

Last Name: Doe

Record Number: 26

User ID: JD26

----------------------

if anyone knows how to do this it would be great if you could tell me.. thanks

[DykstrL]

You can do this with a calculation - cleaner and faster and more reliable:

User ID = Left(FirstName,1)& Left(LastName,2) & RecordNumber

Set the result to be text.

[MadHatter]

hey, thanks a lot.

------------------