Thank you for your post.
What are the exact error messages that are being displayed? This will help focus on the issue.
Connecting remotely will be slower than if the files were local, as data needs to be transferred back and forth across the network.
If your pop-up list is based on values from another table, then the first instance of that pop-up may take a brief time to read in all the values, so the number of values can be a factor. Once the values are cached, subsequent access to the pop-up menu field will be quicker. This would also apply for values generated from a table "3 hops down in the relationship graph".
Also keep in mind that the processor and chip speed under iOS is much slower than on a Mac or Windows machine.
Let me know if you need additional clarification.
Thanx for the adivce. I was thinking about GoZync, but hadn't fully explored the option yet. My solution was originally made to run off the iPad only, then the client wanted to up date his SQL Server with the data, so I suggested using the remote option off the iPad, as I had yet to set one of those up and was keen to see how it works in the real world. Well as you have guessed, it didn't quiet work out as planned .
I think I am going to need to go back a few steps in my design and make everything run off the iPad and then just sync back to the main file when they get back to the office. Updating the SQL Server can be done during the day and thankfully doesn't need to be immediate, but the order forms do need to be done quickly and thankfully those can be emailed to the clients.
Thanx again for the advice.