Thanks for the suggestion Tyler, can't see it producing the results I'm after though. As David says, it would mean a filter for each job folder I think. I have 30 different clients and between 5 and 100 jobs in each, each containing 5-6 folders and various files.
I think it would be really good as a system wide search to be able to use parent/subfolder patterns to find matches where a subfolders sits in a certain parent. Great for narrowing down results on the fly.