I have a fm database connected to an mySQL backend, located locally. All data working and visible.
When I attach a portal to a layout, related records show, but ONLY 3. In every one. This also applies to value lists based on tables within the database.
What is going on? I have looked everywhere for filtering (none) incorrect joins (it happens on every portal for every layout) invisible scripts doing wacky things (can't find any). Is this a limitation of ODBC joining?