Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
I have several lookup fields - search drop down looks for record key instead of lookup value. How can I use the value in the lookup wizard as the search criteria?
Hi,you can join required fields on the Edit SQL query tab and then use these joined fields for search.