I suggest describing the design of your layouts and unerlying tables/relationships in more detail.
The Forms file has a relationship to the Demographics file via a numeric serial number that is hidden. The input screen where this is happening in the Forms file does not have the serial number on the screen at all. There are only two fields on the input screen, both of which are text fields. Upon navigation, every so often the data from one of the text fields is dumped into the serial number. It is jumbled via IWP to the server. The most I can gather from users is that it usually flashes and then demographics disappear. Unbeknowst to the user is that the relationship is broken to the demographic file. I can easily find the record and reenter the serial number to restore the relationship to the demographic file. But I am at a loss as to why it is happening. The pattern I can see is possible low wireless signals. But why would it jumble the data?
Do you then have two files or one file with two tables? Most posts I've read here in the forum report better IWP results when keeping all the tables in one file.
Is the auto-entered serial number defined in Forms or Demographics?
Are the two fields fields from Demographcs or Forms?
Is "allow creation..." needed and used to create the related record?
One key difference between IWP and Simple FileMaker Clients is that your record is not created and thus the serial number is not generated until the user submits their data to the server, but I also do not have any explanation as to why that data would appear in the wrong field.
You might, as a precaution, take a recent back up of your file and run a recover on it to see if recover reports fixing any issues. You might even then test that recovered copy (even if no issues are reported as fixed), to see if that corrects the issue.
It is a two file, one table each file design. The serial number is defined and generated in the Demographics file and set upon creation of the record. All the serial numbers were previously set and were fine up to the point of IWP submission. The two fields on the input screen are from Forms in Forms. Allow creation is in the relationship from Demographics to Forms. The relationship was fine until submission, generally in the same spot. The serial numbers in all cases were previously created and subsequently overwritten with text from one of the fields. It is only happening by IWP users, not filemaker users and only rarely. It seems like the data stream is jumbled by poor connections.
Is the layout where the data is submitted based on Demographics or Forms?
All the serial numbers were previously set
Does this mean that you are editing an existing record instead of creating a new one?
The layout is in Forms and the two fields on the screen are from Forms. It is breaking the Forms serial number or key that doesn't appear on that page. My understanding that only the fields that appear are submitted to the server upon a commit command or navigation. And they are always editing an existing record, not creating one.
Yes, but you have at least TWO records involved, one in forms and one in demographics. Is this process creating a new record in demographics or editing an existing one?
How does the Serial number field in Forms get a value?
Have you taken a recent backup copy of Forms and checked it by doing a recover on it?
The only involvement of the Demographics file is upon creation of record long before the submission is jumbled. Many times, it could be a year or so prior and many submissions may have occurred in between. IWP users are not allowed in the Demographics file. Only two demographic calculations of name and date of birth read only appear on the screen from Demogrphaphics. The record is created in Forms upon creation of the record in Demographics. It is a number field set upon the original creation of the record in Demographics. I have recovered both files. The only purpose of the demographics file at the time of the occurrence is to allow the user to find the record and that is through a related field that appears on the menu of Forms. After the find, the user edits and passes through other screens only in the Forms file, hits a screen requiring a paragraph and it flashes and then breaks the relationship.
What's odd is that if this were a bug in FileMaker, I'd expect to see numerous issue reports of the same popping up in Report an Issue and none have been posted there. You may want to post an issue report there to see what the FileMaker TS techs have to say, but I can see no reason for why submitting data from your web browser is entering data into the wrong field.