I have connected my FileMaker with MYSQL using ODBC driver and now using MYSQL data. It works perfect. However, I want to have a global field inside that remote table so I call allow users to do some filtering. But When i click to create new field in that remote table only data options I get is "calculation" and "summary".
And I cannot amend any existing field to global field.
Has anyone came across this issue; adding global field in remote table or changing existing field to global.
Are FileMaker are aware of this issue.
Many Thanks in Advance.