Thank you for your post.
For this example, I'll assume you have two tables. "Items" and "Estimate". The "Items" table includes your item number, picture, and several other fields. The "Estimate" table will have Name (which may link to a Contacts table), quantity, item number, and other things.
Pull down the File menu and select "Manage -> Database". Click on the Relationships tab, and you will see a graphic representation of your tables and how they are connected to one another. If you don't have a link between "Items" and "Estimate", then click on the "ItemID" in one table, and drag it over to the ItemID in the other table. When you let go, the two tables are now linked.
Now, return to the "Estimate" form that you are creating, and pull down the View menu and select "Layout Mode". On the left side, there will be a number of icons. Click on the icon just below the oval tool. This is the portal tool, and it allows you to see information in the related table (in this instance, the Items table). On your form, click on one corner and draw diagonally. When you let go, a portal is created. Select the related table, and include the Picture/Container field. Size the row (and field) to be one large entry. Return to Browse Mode (from the File menu) and save the changes.
Now, enter something into the ItemID field, and the picture for that ItemID should now appear in the portal.
If you run into any difficulty, or need clarification for any of the above steps, please let me know.
I don't have a "Items" table. I just created this proposal out of a blank database and started drawing text fields. The field under "Item" is a drop down menu with a list of items codes. An example of an item code would be SSTMFL. (stainless steel top mount flat lid chimney cap). On the server I just have a folder with a handful of images (tif format) whose file name matches up with the item code.
My initial thought was to have the salesperson just "right-click" on the container box, click "insert picture" and navigate to the images folder on the server to select the picture for that particular item. However if they could just select an item number from the drop down menu and have the correct photo pop into the container box . . . wouldn't that be a hoot?!
Your response has me thinking I need to create a couple of tables and set it up the way you explained. If I create a "Items" table with the item code, picture and product description - then all three could be dropped in and all the salesperson would have to do is fill in the number of items and amount, right?
Again - when I say you are talking to a very basic beginner when it comes to databases - that could be an drastic understatement. I don't even know how to use Excel spreadsheets.
I'll try your suggestions and let you know if (when) I run into problems. Thanks so much for your help!