I created a similar database for a project at work. I'm assuming that you have a key or a serial number for each film and you are linking that to a field in an 'image' table.
(disqualifier!! I'm not a pro at this, but it seems to work ok, there may be better ways of doing this). I created 2 forms specifically for entering data. On the 'Film' form (for entering Film info), add a button to create images. This button is tied to a Macro, which : Opens the 'image' form. Use SetValue to set the serialnumber field in the image form to the value in the 'film' form. You can then enter all the other image information, and the image is linked to the Film number. Also add a button to the Image form to add another image. This will do the above without opening the form. For viewing all the info (film+image) in one form, I would create a query with both tables, and then create a form from that query. You can put whatever you want in this display form. If you need more help in doing this, don't hesitate to ask. (I know nothing about inserting images tho). hth dk --- [EMAIL PROTECTED] wrote: From: Mark Roberts <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Building a photo database. Any MS Access experts out there? Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit <[EMAIL PROTECTED]> wrote: >I've got an old database in Access '97 if you want to see and example of how it may be done. Actually, Access 97 is what I'm using. What I'm most interested in is a way of automatically populating fields in the "Individual prints" table with information from the "film rolls" table after I enter the film roll # in a form. I'm also looking for a simpler way of embedding the thumbnails: Right now I have to right-click on the thumbnail window in the form, select "insert object", choose "bitmap Image", navigate to the directory where the thumbnail is stored, etc. -- Mark Roberts Photography and writing www.robertstech.com ===== Dave Kennedy Arnprior, Ont. Canada. __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
