CJWatson

Tim, I change the sql and the program now fills the payload with records. It goes through each item in the payload details but doesn't save the information in the actual TO it needs to go. When I look and the pull payload on the mobile side when it loops to set the field , the Layout is not changed to the Actual Data table - so nothing is put in a field to be saved. I don't see a new record request either that creates a new record on the target table. to put the $Field_value in. What am I not understanding. I am assuming the transfer of payload data is done after this comment "If the value of this field has changed..." I added an else to -set field by name($Table_Name & "::"& $field_Name) so that it updates even if the field has not changed

Tim,  Thanks for getting back to me so quickly. I rechecked my TO relationships and did find one error.  Now the process finishes without a FM error, but says there is not records to pull. On the host is 10,000 records but only 5 of them do not have ones. So it should only pull these records I am assuming. The Ipad file has zero records in it.  I am not using an ipad to test, Opened Ipad file with FMPRO 13 to connect to my server ( imac mini on local network with FMS 13 running)  I will load onto Ipad and see if this makes a difference.  Thanks for all the hard work on this project. Much appreciated.  Once I get it working, I am hoping to modify it so a a user can sign on to the desktop and check which records he wants to see on his ipad, then when he signs on the ipad those records are sent at startup. This is an inspection program, so the user would then go and do the inspections. If record is checked complete, When they sync the push would only push the complete items then remove them from the ipad when done.  CJ Watson konafiresoftware@gmail.com Kailua Kona, Hawaii

Won't set field by name. Looks like the field names have been set by your script to be "first_Name[1]" - The bracketing makes the field not readable. Thanks, CJ Watson

Wondering about experiences developing with server running on same pc as fm pro when developing. Filmaker help says server not designed for this, but it seems to work fine for me. Doing a seperation model with ui in fm pro and four files running on server. Get share warning at ui startup but all works fine. Any one have opinion pro or con of this setup for developing only, not for final end use. If this is not optimum what are your suggestions for sep model development. I started with fmpro adv 12 with ui file and four shared files. Then after putting on server had to re - reference 50 tos in the ui. Cant find a best practices doc from filemaker on the development process for multiuser. Moving large app from 4 d into filemaker, so new to development setup . Finding fm easy to learn language, but un sure of above. Thank you, CJ Watson Kailua kona , Hi