auto fill based on another column data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Can't do in a table. Can do in a form that is based on the table.

--

Ken Snell
<MS ACCESS MVP>

mduff said:
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
 
Back
Top