Thank you for your post.
On the server with FileMaker Server installed, make sure you have the correct ODBC driver to access the SQL database (Oracle? MySQL?). Since it was working with your initial test on a Mac, take the driver from the Mac and put it on the server. To verify, try accessing the data with FileMaker Pro from another machine. Once you verified it is working with a FileMaker Pro guest machine, then try it from FileMaker Go.
If you continue to run into difficulty, let me konw what drivers you are using to access the remote database.
Thanx for the help :) I think I am going to change my program a bit to run off the iPad and then when the client is back in the office, have FileMaker update the table that I use to update the SQL table. The one thought I had was, would I be able to update the SQL table that I am using in my relationship graph, or would I need to use the ExecuteSQL script step?
The thought here is that if the table is updated with the correct values as SQL wants it, then when FileMaker is updated on the server it might update the SQL tables. I am still busy looking at other options for now. One other thought was, maybe export the records to excel or xml, and then email the completed form to the office and then the file could maybe used to update SQL that way. It might be a bit of a long work around, but seems like it could work.