Happy Friday all,
I'm attempting to implement some images into our database which will help the user better identify items. I read that its best to separate Character fields from Image fields so I have created 2 tables and linked them through a set based on a PartID field. I have a Parts table (part ID, description, manufacturer etc) and an Images table (part ID, image1, image2). I thought to setup the image fields to Jpeg image rather than Image Reference for the sake of not losing links. The images will be small as not to take up too much time loading. Hopefully I'm on the right track with this so far, if not, please comment.
The next step is to setup a method for the user to easily capture images of these products and link them to the existing records of the Parts Table (parent table). Is there a built-in method to capture images? So far I only see "Import Image" which implies that I'll have to open another program to take the picture, name it something, save it to disk, import the record, and finally delete the original file once its imported...I'd like to press a button on the form to capture and import into the db all at once without depending on third part software or creating extra files.
Surely there is a simple way to capture and add images to the table. I will greatly appreciate any suggestions or ideas.
Thanks!
I'm attempting to implement some images into our database which will help the user better identify items. I read that its best to separate Character fields from Image fields so I have created 2 tables and linked them through a set based on a PartID field. I have a Parts table (part ID, description, manufacturer etc) and an Images table (part ID, image1, image2). I thought to setup the image fields to Jpeg image rather than Image Reference for the sake of not losing links. The images will be small as not to take up too much time loading. Hopefully I'm on the right track with this so far, if not, please comment.
The next step is to setup a method for the user to easily capture images of these products and link them to the existing records of the Parts Table (parent table). Is there a built-in method to capture images? So far I only see "Import Image" which implies that I'll have to open another program to take the picture, name it something, save it to disk, import the record, and finally delete the original file once its imported...I'd like to press a button on the form to capture and import into the db all at once without depending on third part software or creating extra files.
Surely there is a simple way to capture and add images to the table. I will greatly appreciate any suggestions or ideas.
Thanks!
Comment