I have a FilemakerPro 16 solution which reads it data directly from a SQL Server database. I have migrated a lot of data into the SQL Server database. Filemaker is not showing this new data.
I tried reopening the FM solution, refresh records, Add a flush button on a layout which should show the new data in a portal. But nothing helps.
When I connect to the same SQL server database through a new connection all records are visible in the new layout.
Is there any way I can refresh my cached tables?