R
Rick B
Hello all!
I am writing a database for a friend of mine who is a realtor. One of the
tabs on her client form is going to contain pictures of the properties.
Since a property can sell and go from one owner to another, I have the
property in a table separate from the client. I still need to come up with
a way to 'move' properties from one client to another while tracking
historical owners. But, that is for another post.
My question now, is what is the best way to store photos of the properties?
Each property has a unique address as the key. I would like to be able to
build a form where you can see all the property details (size, location,
price, tax valuation, etc.) and have a separate tab to contain the photo(s)
of the property. The number of photos will vary. Ideally, I would like the
tab to contain three small versions of the photos across, and as many up and
down as are available. Scroll bars, of course, when more than will fit the
screen. clicking on the photo (thumbnail) should pop up a full-size
version. Under each photo, I would also need a comment so I can explain
what part of the property it is. When I open that full-sive version in a
separate form, there should be a place to manipulate that comment.
I will also need to know the best way to store the photos. Ideally, on my
property form, there would be a button to "link" a new photo. When clicked,
it would allow me to search my harddrive for the photo and enter the
comments.
Any suggestions?
Rick B
I am writing a database for a friend of mine who is a realtor. One of the
tabs on her client form is going to contain pictures of the properties.
Since a property can sell and go from one owner to another, I have the
property in a table separate from the client. I still need to come up with
a way to 'move' properties from one client to another while tracking
historical owners. But, that is for another post.
My question now, is what is the best way to store photos of the properties?
Each property has a unique address as the key. I would like to be able to
build a form where you can see all the property details (size, location,
price, tax valuation, etc.) and have a separate tab to contain the photo(s)
of the property. The number of photos will vary. Ideally, I would like the
tab to contain three small versions of the photos across, and as many up and
down as are available. Scroll bars, of course, when more than will fit the
screen. clicking on the photo (thumbnail) should pop up a full-size
version. Under each photo, I would also need a comment so I can explain
what part of the property it is. When I open that full-sive version in a
separate form, there should be a place to manipulate that comment.
I will also need to know the best way to store the photos. Ideally, on my
property form, there would be a button to "link" a new photo. When clicked,
it would allow me to search my harddrive for the photo and enter the
comments.
Any suggestions?
Rick B