OLE object "gallery" on form

ahseenam

New member
Local time
Today, 15:56
Joined
Nov 16, 2011
Messages
8
I have a table listing housing property data with the following fields.

PropertyMaster
ID (PK)
StreetAddress1
StreetAddres2
City
State
Zip
Image (OLE Object)

I've made this table into a form (PropertyForm) with a bmp image showing.



Now I actually want to create a "gallery" so people can click to cycle through images rather than just seeing one.

So I have another table, and each property will have many images. (Many to one relationship)

PropertyImages
ID (PK)
Image (OLE Object)
PropertyID (FK, PropertyMaster.ID)

So now I want just that property's image(s) to show up on the form.

This query should get me what I want, right?:

SELECT PropertyImages.Image FROM PropertyImages WHERE PropertyImages.PropertyID = PropertyMaster.ID


My question is how do I actually make this image gallery appear in the form?
 

Users who are viewing this thread

Back
Top Bottom