Auto Enter Multiple Field Issue

[virgonova]

When importing multiple images, I need two fields to auto enter serial #'s (ID# and Image#)

The ID#'s import in the correct sequential order but the Image#'s do not. The field data looks like this:

ID# 1265

Image# P01265C1ADT

The serial # for the Image field is updating the wrong #, like this:

P01265C1ADT

P01265C2ADT

P01265C3ADT

I need it to update like this (to match the ID#)

P01265C1ADT

P01266C1ADT

P01267C1ADT

I do not have the option to rename the image field content (these images have already been archived under the current naming format)

Is there a calculation that will specify which number set to update? (not C1, C2, C3 but P01265, P01266, P01267)

[Slobey]

Is the C1ADT a constant? If so you can make it a calc of ID# & "C1ADT"

[sbg2]

Didnt we already go through this?

"P" & (Right("00000" & ID,5)) & "C1ADT"

If your not understanding the formula look at it like this:

If you put 5 leading zero's on any ID# then count from the last character back 5 characters you end up with a 5 digit number with the appropriate number of leading zero's.

ex.

ID# 5

"00000" & "5" = "000005"; last 5 characters (or 5 Right characters) = "00005"

ID# 123

"00000" & "123" = "00000123"; last 5 characters = "00123"

ID# 2471

"00000" & "2471" = "000002471"; last 5 characters = "02471"

ID# 98765

"00000" & "98765" = "0000098765"; last 5 charcters = "98765"

ID# 123456

"00000" & "123456" = "00000123456"; last 5 characters = "23456"

[virgonova]

Thanks that worked, I just added "P0" & ID# & "C1ADT" to match the naming format.