Automate

 View Only
Back to discussions
Expand all | Collapse all

Filter on Lookup control like a dropdown?

  • 1.  Filter on Lookup control like a dropdown?

    Posted 2 hours ago

    Is there a way to filter a lookup control in the same way that you would filter a dropdown? I have an RDL setup with these 3 fields and I want to filter the lookup to only show the GL_Numbers where it equals the sales org and dist channel. It works with the drop down, but there are a lot of choices so we want the user to be able to lookup the value as well instead of scrolling through many choices. I tried this raw query, but it didn't work. 

    Company_Code = '[/my:myFields/my:Sales_Organization]' AND Dist_Channel = '[/my:myFields/my:Distribution_Channel]'



    ------------------------------
    James Polley
    RAYTHEON COMPANY
    ------------------------------