Primary Key ralation to Images

G

Guest

First of all Thanks for taking the time to read this SOS for Help
Please “if possible†reply back to: (e-mail address removed)

I’m using MS Access 2000 with SP3 under Windows XP Home
My first field is the item number; which is also the primary key

And I have a group of pictures which are for each unique item number

What I would like to have explain is… who do I – no having to do it one by one
In the (design table or other possible way)
Create a relationship from the item number (Primary Key)
To the picture in my files (there are all in a separate folder on the hard
drive)

Ex.
Item num. #### <primary key
Description
Price
“and so onâ€

then on a square to the side the corresponding picture of that item

of course the file name for the pics is already named after each
corresponding number in the Item number on access; but I don’t know how to
make the relation for each one to show in a square to the side of each item –
if its done with OLE OBJECT I haven’t been able to figured out.

Thanks to anyone that can help me with this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple field primary key problem 2
stock in hand 3
Changing Primary Key 1
Primary Key 1
primary key - concatenated or autonumber? 6
Only show certain records in main form. 1
Primary Key 2
Update primary Key. 1

Top