In our current database we have a table of contact information for our clients. On a shared network drive, we also have a filing system where each one of these clients has a folder with relevant documents inside.

I've set up a script that can will take the user to the client's folder in windows explorer, given the file path. What I'd like to do is come up with a user-friendly way for a user to input that file path into the client table. Up until now we've just been copying and pasting the path from explorer. Is there an easier way to do this? I'm imagining dialog box similar to the way that you can insert files into containers, except in this case we'd be selecting a folder instead of a file.

Perhaps you can make use of this (free) plugin provided to the community by Adam Dempsey.

http://mooplug.com/features