Re: Building a photo database. Any MS Access experts out there?

[Dag T]

I didn�t get as far as thumbnails, but it is possible to have sub 
schemes and in the schemes.  I�ve done this to insert a list of 
categories (search words).  You may be able to do the same thing as I 
have if you insert a sub table incorporating the film information in 
the scheme for each picture.

I don�t have the database here (I have gone home for today) but can 
have a look at it tomorrow.

It�s been a couple of years since I made it, so I�m a bit rusty in the 
details.

DagT

I can take a look at it
P� tirsdag, 9. september 2003, kl. 16:13, skrev Mark Roberts:
<[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.