Forum Discussion
Filter different record in one column
So the solution was to refresh the table and it worked. But for furture readers. You have to create an extra table where you create a row for each search option for a record. For example apple has the release column P2 (P3). Here you create 2 rows where there are an apple P2 and apple P3. Then you create a relationship between these 2 tables and now you can use them as filters.
Hi Anonymous
Unfortunately it is not good, as I have 2 information in one column. For example I have this record : P2 (P3) .
And I want this record to show up in P2 search and P3 search as well. I have created a table where there is list of record which P-s have it.
So the solution was to refresh the table and it worked. But for furture readers. You have to create an extra table where you create a row for each search option for a record. For example apple has the release column P2 (P3). Here you create 2 rows where there are an apple P2 and apple P3. Then you create a relationship between these 2 tables and now you can use them as filters.