Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to use the Search Box to select the searched value in two separate fields instead of selecting it in field A, clear, select in field B? The value my users are searching is identical in Field A and Field B but the joined data is different.
maybe with the ctrl + click if the values you choose in the fields are compatibles
Does not work.
why not?
this is my very little db
I do not believe the search field works that way - it is designed to allow you to enter a string of data and then it matches that string to the field or fields that are defined to be in the search
is it posible to make a dimension out of the combination of the fields you are looking for (if that is even logical in this case)
I can CTRL+CLICK both like you show but the selection does not apply. 1 record shows Group A and Manager 1, Manager 2. I want return all groups where the searched Manager is in Manager 1 or Manager 2.
I think I'll create a new table with Group and Manager columns, populate it with the unique group and manager combo, then search on the new field.
that sounds like the way to go - the user can then start typing the group and manager combo names ans will then get matches