AnsweredAssumed Answered

Setup Keyword Search

Question asked by KAmsinger on Feb 17, 2011
Latest reply on Mar 8, 2011 by philmodjunk

Title

Setup Keyword Search

Post

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.

Thx You!

Outcomes