Need input for Photo Database

[JD2775]

Hi there,

I am trying to create a database at work for photo storage. Each photo will have a title. In addition to this an Excel sheet will be imported with Date, Person who took photo, Comments, and Photo ID number.

What I want eventually is a layout where you can search for an ID number, or Date, or whatever and return the text data as well as the photo.

Also, since there will be many photos uploaded over time it would probably make sense to make the pictures reference files, to save database room.

Any input on the smoothest way to go about this? Anyone else have photo databases they have used in the past?

Sorry if this is posted in the wrong section. I didnt see a "general" section, and this one looked the best.

Thanks

[JD2775]

Or, if someone has a better idea on how to arrange this I would love to hear that as well. Basically pics will be taken with a camera, and ID numbers and data scanned with a PDA simultaneously.

Thanks for any input :)