I created a new table where users can add records to. The records they create are displayed fine through a portal, but they do NOT show up in the table view of the table - It contains zero records.

However when i perform a search in the very same table, i get results! I find the 3 records that should be there, and the search result is : 3 / 0 Found.

When i do show all records, it goes back to zero.

I am clueless. I must be doing, without a doubt, something very stupid! But i've been working with FMpro for many years and i have never experienced this before. Where are my records stored?

See screenshots.

show all records:

search results for "peter"

I just noticed that the records become invisible when they are added by the users through IWP

If i add them directly in the application they are ok.

But that still does not explain why i can see them only if i search for them..

Restarting all instances of the application solved the problem, records do now appear when they are created.

check the database for corruption too.