Thank you for your post.
I am unable to replicate the problem with FileMaker Server 12 running on Windows 2003 Server, and access by FileMaker Pro clients on Mac OS X 10.7.3 and Windows XP (SP3).
If you download the file locally to the client machine, are you able to select "Add Leading Group by St"? If so, host the file in FileMaker Pro 12 and have one of the other machines access the file. Does this work?
Do you have full access to the hosted file?
I'm aware this occurs on 5 of your 20 databases, so anything you can tell me about the differences between those 5 files from the other 15, no matter how minute, may be helpful in reproducing the error.
It does work like it is supposed to on any other machine expect mine Locally or Remote. So I must have a desktop problem.
I have full admin rights to my desktop and full admin rights on the server. However, after checking the log on the server there are many authentication errors. This is odd. I verified this with my IT department.
I only check 5 of the 20 databases so my assumption was that they would all react the same.
I think I need a new image or machine.
Thanks for your help.