Hi Smartchap
Thanks for the reply.....
The Photo & Doc's folders are generated automatically when you create the next investigation referred to as [CustomerID], theses are now created sequentially. However the earlier jobs did not create Photo & Doc folders when a new file was opened, they simply created the ENF xxxx folder
Hope this all makes sense….

See the extracted text below from the complete...

HI.... Another newbe to the site.... looking for a little help.

I have a DB for the purpose of Invetsigations, each time that a new case is opened the process generate two new folders (1.Photos and 2.Doc's) these are contained on the server in K:\Enforcement\ Investigated_Ca ses\ENF xxxx (xxx=the new job number)

My team download photos taht are taken and are supposed to save them into the respective Photo folder.... unfortunately,...