I've got a database with multiple tables and I'm running a script from a window that has focus set to [let's say] table 1 and requesting the creation of a new record in table 2.

 

I've traced the execution of this script in FM Go [using the pause steps] and see that when the 'record create' step is executed, the record in table 2 displays exactly as it should.

 

I then execute the 'commit' statement and all of the fields lose their data values and display the "?".

 

I removed commit' statement and get the same results. Strange

 

Now . .  if I exit FM Go and re-enter, this new field is gone [poof ! ! !].

 

This only happens in FM Go. When I execute the script in FM Pro everything works perfectly.

 

All the script steps are iOS compliant.

 

I'm sure I'm missing something quite simple but at this point don't know where to look.

 

Thanks for any advice.

Can you post the script here? 

Or a copy of the File.

I know this is an old post but I have experienced this if FMgo has a file open and the iPad goes in to hibernate mode.  you have to completely restart the iPad and that seems to resolve the problem.  I'm not sure what the over all fix is for this problem