Hi,
I'm not sure if this is the correct forum to be asking this question, but I
hope still to be able to get some help.
I work for a photography place at a golf course where we take pictures of
each group of golfers and then sell the pictures at the end of their round.

I want to have a database that contains the following info: 1. an employee
table (employee name, etc...) 2.then a table that can keep track of the
photos that are taken on a daily basis and which employee shot the photos.

We always save our photos like this: C:OneUser/MyPictures/4 digit
year/Month/and then the last folder is 2010_04_16_YM (today's date followed
by the initials of the photographer)

Heres
a demo that shows kinda what I want....

Theres a link to a demo that shows kinda what I want....except instead of
the subdatasheet he is using, I want a table that shows each photo taken that
day represented by its filename which is a hyperlink to the location of the
photo on our computer. The main table will have the date as a field and our
name as a field on the form to fill in, so this will translate into the
folder that we created or imported that day. (based on the method of naming
or folders mentioned above)

My goal is to be able to search by date and see what pictures were taken and
the sales, employee who took it, etc... through Access.

Please let me know if this is possible.

Thanks for your time!
Yvette