I have a problem with ESS in FM 12 that's linkinked to an external MySQL data source.
Basically, if I get an existing TO linked to an ESS table and re-point it to the same external table, FMP creates a new table in the file. Also if I duplicate a TO linked to an ESS table, FMP creates a new shadow table in the file.
The existing shadow table has about 64 fields in the external table, and about as many more local calculation fields. The ew table that is created has only the native fields in it.
I have done consistency checks, compressed saves, none have worked.
Hosted on FMS 220.127.116.115 running Mac OS X and using the Actual ODBC driver. The external MySQL table is on an external host somewhere. Client is FMP 12.0v4 Mac OS X.