AnsweredAssumed Answered

Search portal for 2 fields containing the search word, and one dropdown

Question asked by cillion on Mar 10, 2016
Latest reply on Mar 14, 2016 by cillion

Hi out there!

Im stuck trying to make a search field, that is going to show portal rows that containing the search value, so if it find the value in one of those two field the row will show. The dropdown will be addon filter for the search field, to narrow the search futher down on a third field. I will appreciate all the help I can get

 

This is my setup now, I know am on to something but not quite there yet:

The layout looks like this, the Company field is going to search on and show find in either Current Company or Previus Company

 

2016-03-10_19-14-24.png

The Find_People table have I made like this:

2016-03-10_19-20-04.png

 

And the relationship between the tables like this.

2016-03-10_19-20-46.png

Outcomes