AutoNumber Field Format

[andy-29]

I have a Style #(foreign key) field that is a lookup from another table.


I'd like to somehow modify the format/display of the ID field.
The ID field will pickup the Style# chosen from the combo box and combine it with the ID field???
ex: user chooses style # from the combo box "T5640", ID field would now show T5640-1 (Style # + autonumber increments)
Is is possible??

[June7]

The ID field is an autonumber data type? Can't modify the data in table but can calculate a value in query or in textboxes by concatenating the two fields. The ampersand character is preferred concatenation operator (as opposed to + sign).

[Style #] & ID

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in any names, nor reserved words like Date as names.

[andy-29]

ID field is autonumber.
I created "Image ID" field in the same table as the ID and Style # fields. Table name marker details.
I'd like to have Image ID field to have default value = [Style #] &"-"[ID]. How do I go about this?

[June7]

This is a calculated data type field in table? I haven't used those yet. See if the calculated field will accept concatenation expression. Otherwise, will need code to save this value into a text field. Don't advise saving this calculated data into table. Calculate it whenever need.

[andy-29]

Hi,

I attached test db. I think almost got it. The only thing I'm not getting is when I create a new record on the marker details subform the Image ID is only getting updated with the Style # field but it will not append the ID field - [Style #]&"-"&[ID]. Maybe you can figure out??

Thanks!

[andy-29]

Ok, solved it using the calculated type field...works with concatenate and I got what I needed