Attachment field, pictures and forms

[kpo]

Hello,



I am a self taught Access "advanced beginner". I built an inventory database for our company to use and am looking for a way to streamline entering parts into our database. I have a table (tblPartInventory) with fields for ID (Auto Number), manufacturer, type, size, part, piece number, part number, comments, condition, shop location, shelf location, status, employee, and picture as an attachment field (our owner wants a general picture for each part as a reference).

I have built a form for entering parts and everything is running smoothly. I "idiot proofed" the form by building a different table (tblPartList) with a list of all the different parts we carry. So as parts are entered, the form auto populates a combo box from the appropriate tblPartList field. The manufacturer, type, size, part, piece# and part number all pull from tblPartList. Which is working properly. I should note I don't have them related as tables. My tblPartInventory table is basically "format-less". I have formatted the forms to filter or restrict that data that gets entered into the table. Right now it is only me entering parts but that is soon to change as we add inventory from other shop locations. When I enter parts, through the form, I manually attach a picture to each record of information. (The owner was very specific about pictures accompanying the parts in the database.)

My question is this, if I add an attachment field to tblPartList and add pictures for each record in that table, can I then have my entry form "auto populate" the attachment field in the form with the attachment in tblPartList?

I am sorry if this seems confusing. Let me know if you have any questions I would be more than happy to try to clarify myself. If I need I can attach a copy of the DB.

Thanks in advance

[June7]

Be aware Access has a 2gb file size limit. Images saved in attachment field can chew up that limit (database 'bloat').

Review https://www.accessforums.net/queries...eld-35981.html