SQL Records showing as Question Marks
I am trying to sync my FMP databast to SQL Server for the first time and a funny thing is happening. When I open the linked database in FM, it shows the correct number of records. In Table View, I can see the first few records , but everything below is filled with question marks. Then, after a few seconds, the number of records decreases to 6. As far as I can tell, no data is destroyed on the SQL side. I suspect something is corrupt in the data, which causes it not to display properly. I was wondering if there is a setting or something I should monitor to make my records are visible.
I am running FMP 11 Advanced for OS X