Setup Keyword Search
Here is what I want to setup in my already existing database. I am on FMP 10 Advance.
I have a database that has lots of tables which each table includes text fields, portals, value lists, pretty much everything you can imagine. What I want to do is create a new table within this database that a user can enter in a keywords separated by commas and hit find and all records that contains those keywords in any type of text field or portal will pull up either in a new window or in the records parent table and show all the records in a found set and the user can review each record.
Here is the thing, which I am not sure if this is an issue. But I already created the database and we have almost 15,000 records just in 1 table alone and have over 10 tables with tons of existing records in each. So I need this feature to work on existing records and text already in each field.
Any help with this would be appreciated.