AnsweredAssumed Answered

Multi-key relationship using MYSQL database

Question asked by DavidTinoco on Feb 16, 2017
Latest reply on Feb 21, 2017 by beverly

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?

Outcomes