auto fill based on another column data

[mduff]

I have a column called ProductID, I also have another column called thumb_image with a default value of ../images/gif/ and then I have one more column call full_image with a default value off ../images/jpeg/

I need to have the productID data be displayed after the default value of ../images/gif and ../images/jpeg

Ex..
ProductID =2555
thumb_image= ../images/gif/2555.gif
full_image= ../images/jpeg/2555.jpg

Any help would be greatly appreciated
Please if responding via e-mail send response to (e-mail address removed)

 

[Ken Snell]

Can't do in a table. Can do in a form that is based on the table.

--

Ken Snell
<MS ACCESS MVP>

I have a column called ProductID, I also have another column called

thumb_image with a default value of ../images/gif/ and then I have one
more column call full_image with a default value off ../images/jpeg/

I need to have the productID data be displayed after the default value of

.../images/gif and ../images/jpeg