Hi all,

I have the product table. For this I have to add multiple keywords for product. For keywords I use the another table.

Now I need search the product based field keyword. Based on the keyword search, I need to show the products having the same keyword.

Kindly give the solution for search based on relation table.

Thanks

Automatic message

This topic has been moved from "Community Resources → FileMaker Pro 12" to "Database Schema & Business Logic → Finding & Searching".

How many tables do you have now? 2 (Products, Keywords) or 3 (Products, Keywords, and a join table between the first two one)?

Now I need search the product based field keyword. Based on the keyword search, I need to show the products having the same keyword.

Search the Products table. Enter the search criteria into the related field from Keywords. If you are scripting this, it will look - roughly - like:

Go to Layout [ Products ]

Set Field [ Keywords::Keyword ; <your criteria> ]

Perform Find[]

Hi all,

Thanks for the reply,

I found the solution for this,

Go to Related Record will work to find the products based on the keywords found set.

Thank you.