Hi.
I'm hoping someone can help me with this search issue.
I have created 6 new fields within the Company entity.
All fields are created the same except for the column name being different.
I also have all fields pointing to the same Lookup Family:
Entry Type: Selection
Column Name: comp_allcomm, comp_comm1, comp_comm2, comp_comm3, comp_comm4 and comp_comm5
Caption: Commodities
Lookup Family: comp_allcomm
Each field is populated with a product selected from the comp_allcomm field.
So, I thought I could just add the comp_allcomm field to the company search screen (which I did) and when I search on it (ie. comp_allcomm), it would return the companies associated to the product found within the fields above.
- Unfortunately, I'm wrong with this methodology as nothing is returned.-
However, if I search on comp_comm1, it does return a value but only those who have been selected within this field.
So, is it possible to search on 5 fields at once from 1 designated field? I thought I was doing this by selecting the data from the lookup family.
Let me know.
Thanks,
Steph