OK, so maybe I'm asking too much of Filemaker here but is it possible to have two text fields auto-fill a third field?

I've got a database for the user community that I support and there user-name/authenticator is always going to be their first initial and their last name (i.e, David Jones - "djones".)

Ao I have a last-name field, a first-name field, and a user-name field - is it possible to create a script or calculation to autofill the user-name field with just the first letter from the first name-field and the contents of the last-name field to auto-fill the user-name field?

Thanks for any help...

Left ( firstname ; 1 ) & lastname

or to limit the length of the username to 8 characters

Left ( firstname ; 1 ) & Left ( lastname ; 7 )

Thanks Vaughn, that did it!