Hi all, I'd very much appreciate your advice with this situation. Reason being is that I don't know much about access but I'm willing to learn if I know its a good solution!
Situation
lots of photos are taken at different locations, dates, times for different customers. Photos are stored on a NAS by year/month-day/location/some-other-folders
The bit that I want to ask you guys is this! Can you integrate access records with a folder that holds a location's or a customer's data? This path could be set when the other customer data is entered into the database. Ideally I want to streamline the input of non-imagery data (customer name etc.) and the access of associated imagery directory from these data.
The alternative I'm looking at is a tagging filesystem approach with www.lunarfrog.com this may make more sense.
Thanks very much, apologies if this is already in the forums. I tried searching but was a bit overwhelmed.