how to built a database of Graphical elements, such as logos, etc

[xtracalm]

Can you tell me how I can creat a database of all the products that I sell
linked to the image of the product and the respective price.
for example: when in a dropdownlist toothpaste is selected, the image of the
paste and the price appear in the field.

 

[Damian S]

Hi xtracalm,

Have a table similar to this:

tblProducts
ProductID autonumber
ProductName text
ProductImageFilename text

and store the path/filename for the image of the product in the appropriate
field.

Then, use an image control on your form, and have a combo of Products to
select. In the After Update event (or on click event) for your combo box,
have me.IMAGECONTROL.picture = me.COMBONAME.column(2)
replacing the names of teh controls with appropriate names.

Hope this helps.

Damian.