Combining Field Data

[merciless32]

I need to combine a record number field and a user ID field to create one unique field. For instance...Record 0001, User All2B, needs to return A112B0001. Help?

 

[varunmathur]

Hi
use the "&" ie concantenation operator. This will combine the two feilds
eg [first name]&[surname]
This should solve your problem
varun

 

[merciless32]

That helped! Now, the problem I am having is that the Record Number is an autoupdate numeric field. When I combine it to the User ID text it drops the leading zeroes in the Record Number. I tried setting the field format and input mask to ##########. I am still unable to combine the fields with the zeroes in tact.

 

[David R]

Did you set the format in the combined field or the autonumber field? I think if you do the latter, the format will carry through to the combined field.

HTH,
David R