I'm designing and working with my first Filemaker database using Filemaker 12 Advanced and Ipads using the Filemaker Go app (self hosted). I am having issues with random records going missing from the whole database (in each table and TO). There is no evidence that the record was ever in the database at all and this only happens every once it a while and is not restricted to a single Table; it happens in multiple tables, randomly, with no correlation between the instants. I would say 1 record in 50 goes missing daily.
I have 9 main tables that are connected with a key. Each table has TO of every other table attached to share information through portals on each table. Table1 can create/delete records in Table2, but not vice versa, Table2 can create/delete records in Table3, but not vice versa... and so on and so forth. I am the only person who can delete records at all but especially from Table1, which removes the record from every table in the Database. None of the TO have the ability to create or delete.
What could my issue be? I checked relationships, scripts and fields. Could it be the Filemaker Go app?
Thanks folks!