I have just encountered a serious problem with a database hosted on Filemaker Server 17. The last added record does not show up in a table (table view layout), despite "show all records" is set. However, the same record can be found by a search in the same layout. Shutting down the client and opening up the database again resolves the problem.
The strangely disappearing records have been generated in a layout based on a different table instance via a relation (the relation is setup to generate new records in the related table).
I am using the latest client version of FM Pro Advanced (22.214.171.1240) and Filemaker Server version 126.96.36.199.
I have restored the database locally with FM Pro Advanced and uploaded again to fms, but with no success.
Has anyone encountered a similar behaviour yet? Are there other options to check or repair a maybe corrupt database?
Thanks very much in advance,