Hi!

I'm making a for for logging awards for players and I want it to show the
award images as I select the award. I use two tables (the log and the award
one) and wonder how to link this up.

Table 1 is Log, primary is a running count
foreign key linked to Awards is the Awardname
Awardname have a lookup function checking table 2 for available awards.

Table 2 is Award, primary is Awardname
it contains image and image2 columns (embedded ole)

On my form (for entering new data in table 1) when I select an award from
the lookup list I want the 2 stores images (in table 2) to load and show
next to the data I'm entering.

How can this be done? Bound OLE object? but how to link?
Did I miss any needed info?

Thomas Andersson wrote:

Hyperlink. It can contain 3 parts; display text, address, subaddress.
Typically the first 2. The parts are separated by the #. Entering
Me.HFld = "Award 1#C:\Test\Award1.Hpg"
will show Award1 in the text box and clicking open the picture.

See also FollowHyperLink and HyperlinkPart in help for more.
HyperlinkPart will permit you to separate the sections out.

If you drop an image object on the form and open up the property sheet
for it you will see 2 properties in the Format tab; Picture and
PictureType. Picture is the path (gotten from hyperlinkpart) and
Pictype is Linked so you don't bloat).

http://support.microsoft.com/kb/210100

You could have 2

Salad wrote:

Hmm, not quite getting that but doesn't sound like what I want. If you just
forget about the info happens to be a picture it might get clearer.
When selecting something in the lookup list when entering data for table 1 I
want a related bit (non editable, just for show) of info from the linked
table 2 to show on the form.
Clearer?
The info I want to show just happens to be 2 imbedded images in Table 2.

Thomas Andersson wrote: