create login

[dharkin]

Hello Forum,

I want to create a login from the first name and last name field. I want to pull the first initial from the first name field and first seven characters from the last name field to create an eight character login to be displayed in a login field. Can some tell me how to perform this calculation

Thanks in advance Don

[Reed]

Use the Left() function.

Left(FirstName;1) & Left(LastName;7)

If you want you can then make accounts using these logins with a looping script.

Dana

[dharkin]

Taking it a step further Dana if you have the time to respond. How can I keep the first letter of the first name and the first letter of the last name all lower case. Also, can you give me an idea of the looping script you speak of?

Thanks for your help

Don

[Reed]

Lower(Left(FirstName;1)) & Lower(Left(LastName;7))

Loop

create account(login field;some initial password)

next record(exit after last)

End Loop

The script would cycle through records in the table that contains each login.

[dharkin]

Thanks so much Dana