How can you generate alphanumeric serial #?

[surfer]

Hello-

I have a database where I would like FMP 7 to generate an alphanumeric serial number based on 1 or 2 fields in the record, (i.e. the team and the member).

For example, John Smith of the Yankees would have "YJS123456" where 123456 is the number that was created and appended to the "Y" "S" and "J".

Is there a way to do this automatically?

Thank you...

[mse]

http://www.nightwing.com.au/FileMaker/demos1.html#d7

[Fitch]

Generate the serial number in a separate field, and make it auto-enter a serial number. Then combine it like this:

Left( Team, 1 ) & Left( NameFirst, 1 ) & Left( NameLast, 1 ) & SerialNumber

Make sure the result is of type text, not number. If you don't have first name and last in separate fields, it would look like this:

Left( Team, 1 ) & Left( Name, 1 ) & Left( RightWords (Name, 1), 1 ) & SerialNumber

[surfer]

Thank you! These are great solutions. I appreciate the help...