OLE images in a form (slight twist)

[Mike]

I can add images to a table and get them to display on a
form when specific records are chosen. But this is done
with each record having a unique picture. No problem
there.

But I want to link a table of a set number of pictures
(e.g. product type images) which will display a picture
based on the product type chosen in another field on the
same form. In otherwords, the same image might be
associated with multiples of the same product type.

My complete example is:

I have an inventory database. I want a picture of a
specific model printer to display when I chose that model
from a combobox. The number of product images would be
equal to the number of different models (OLE image field
could potentially be added to the 'Model' table
perhaps?). But the total number of records would far
exceed the number of images (e.g. 200 HP LaserJet 4050N's,
150 HP VL400's, etc). But as long as the specific model
is being viewed, I'd want that particular image to be
viewed as well.

There may be a simple solution, but I've been looking and
I'm afraid my mind is fried now. Can anyone help?

Thanks in advance!

 

[Guest]

A-HAAAAA!

Figured it out.

1- Created a separate table for photos of the different product types. ID field (autonumber & primary key), and Photo field (OLE object with saved photos).

2- Created Photo form from newly created Photo table (used wizard)

3- Added Photo ID field to main table.

4- Edited database relationship and added a one-to-many connection (all records from main table and only equal records from Photo table).

5- Created subform on main form and followed wizard (use existing tables & queries>Photo table (add both fields)>link fields (option provided in list perfectly defined what I wanted to do)>gave it a name>VIOLA!

Cleaned up the look of the form and did some basic tweaking of settings and it was done!

FYI