Hello All,

I am new to this forum and I am a novice at filemaker. I am creating a database in which every record I create has an auto-entry serial created. What I would like to do is, based on the current user, add some text to the beginning of the serial. EI: If user A is currently logged on then "A1, A2, A3, etc." If user B is logged on then "B1, B2, B3, etc." The solution I have found is creating a script, using:

*New Record/Request

*Set Next Serial Value

-Let ([ Acct = Get ( AccountName ) ;

ID2 = ProspectIntake::ID#] ;

If ( Acct = "A" ; "A" & ID + 1 ;

If ( Acct = "B" ; "B" & ID + 1 ;

If ( Acct = "C" ; "C" & ID + 1 ; "" )

)

)

)

What I have found is that this doesnt work for the first record created after changing into a different user. Would any one have any suggestions?

My suggestion is strongly NOT to do it. If you create your serials this way, then you find out the wrong user has been signed on (hey, it happens that they forget if they borrow another's computer) then you're in trouble. If you have created related records based upon this serial, you can't change them or you break your relationships! The serial will be worthless to tell you anything anyway.

Serials should be meaningless. Use another field to know which User was working. If you need, you can then combine them in a calc field any time you wish. Appending a serial yourself instead of using FM generated auto-enter serials will also break in multi-user mode.

LaRetta