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?
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?