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
The Find_People table have I made like this:
And the relationship between the tables like this.