Question a tough one

[psuplat]

Hi everyone.

I'm having a problem with a database design, and don't know how to bite it.

I need to design a COSHH database. Everything goes nice and smooth until the point of pictures. Every substance that is on db will have to assigned pictures representing symbols of hazard or ppe. obviously there is no point to add an images to every record because db will go huge in size and we talk of about 30 pictures that will be repeating itself. i tried to put images to different table and refer them but i doesn't work.

I really don't know how to go about this, any ideas? how to assign multiple records from table to a record in other table, is it possible?

db made in access 2003

thank for any help

 

[vbaInet]

Here's a way. Have a read:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285820

 

[psuplat]

I've been trying that one. but still got few problems.
on it's own in a simple form this works, but my form is a bit complicated.

the whole thing includes to tables: substances and pictures

table pictures has fields "picID" and "path"

table substance includes, among other fields, hazard1, hazard2, hazard3, ppe1, ppe2, ppe3.

the values in those field are related to picID in pictures table.

on the form the user select the value of pictureID from dropdown list

Now, image won't display because it needs image "path".

I went about it be creating a hidden list box that runs a query retrieving the "path" based on the picID from the dropdown list. but the image still won't display.

i "unhidden" the list box for testing and found out that image will show the moment click the value in listbox

but i don't want people to click anything or even see the damn listbox

any ideas how to do it, any other way the listbox to go around it

 

[vbaInet]

Use the VALUE of the textbox (i.e. txtbox1.Value) to get the path from the textbox. Also ensure that you call the "DisplayImageWeb" in the AFTER_UPDATE event of the listbox.