8 Replies Latest reply on Feb 21, 2017 1:07 AM by beverly

    Multi-key relationship using MYSQL database

    DavidTinoco

      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:

       

      name

      keys_Name

       

      If name = "Apple", then I've set up a PHP script which makes

      keys_Name = :

      A

      Ap

      App

      Appl

      Apple

       

      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?