I'm stumped

[looneytunes]

hi all - i know there are many threads relating to linking pictures to records etc, but forgive me for asking one more time:

I have managed to get pictures into my dbase - using Microsoft KB help - by linking them in a table to an external source.

However, I want the dbase to know which picture is for what details. eg. I have a cars sales dbase. I have all the pictures in one folder of all my cars which are linked to the dbase. When I pull up car details in the form, I want the picture to come up aswell - the correct picture.

Pls let me know if this has been done. Sorry for extending this topic; however, I could not find a "simplish" soln. to this.
Thank you once again

 

[maxmangion]

check this demo posted by oldsoftboss, it should sort out your problem.

 

[looneytunes]

thanks very much for the reply - the demo helped.

one more query needs answering though, please:

is there a way i can put a an image control on one of my forms and set the criteria so that it has to equal that of the current record? e.g. if u are displaying registration number: "F423FDS" then the picture should be of that record.
I have linked my Image table to my Cars table and have a RegNo field in my Image table.

If not, is there any other similar way to approach this? If not, I shall stick to the current method of linking to another form and selecting the image to display

Greatly appreciate ur help

 

[looneytunes]

sorry..................

hi, i am sooooo sorry - i just figured out a way to do it!
thanks for ur help

ps. the admin may want to delete this thread as it might appear to be useless! sorry

 

[maxmangion]

it's nice to hear that you sorted out your problem. However, the credit should go to oldsoftboss