Filter a data master on multiple attributes
First I apologize if this question was already answered, but I could not find out any working answer in the existing topics.
My question is quite simple :
I have a data master with two fields : "ID" and "Name".
I want to simulate a search on a data list, where the search is run on both criterias "ID" and "Name" and returns any line where there is a match either on "ID" or on "Name"
example of my data master :
If I search "2" or "Bob", i would like to get the result : "2, Bob".
At the moment I succeed to run the search either on "ID" or on "Name" but not on the two at the same time. How could I achieve this ?
Thanks for your support!