I recently set up an ESS (MySQL) in my FileMaker database.
I have another table with a global field called "search"
In the MySQL table, I have 2 fields:
If name = "Apple", then I've set up a PHP script which makes
keys_Name = :
I tried to match the global search field to this keys field, but I am getting no records in the portal I created, even though it is a indexed FULLTEXT field.
Are multi-key relationships available with ESS?