FileMaker Server 18.104.22.1684
10 iPad clients
1 FM Pro Client
Prior to that, over 52K transactions have been processed without a single glitch. Since then I've seen the above happen twice.
This is the result I get after doing a find for the value 0 in that field. The field is also used in a table relationship to limit records to active transactions. I can type anything in that field and close and reopen the database and it will display what I entered, but still treat the field like it has a value of 0. If I search for 12 it returns the one record, so it's almost like the field has two values.
Any ideas how this is happening?