Hi,



I know you can add a custom WHERE clause in a BrowseDialog's Searching event when you know the specific values, ie.



WHERE my_Car IN (0,1,2)



But can you do this?



WHERE my_Car IN (SELECT carid FROM myCars)



Is this possible?



Thanks,



Aaron

Yup.  In the most recent version of the BrowseDialog in the latest update, you can go at this two different ways.  There are two new properties called OverrideSearchTableName and OverrideSearchTableSchema which allows an alternate table or view to be used instead of the underlying BO table name.  This allows you to get as flexible as you would like.  You can also create place holders for inline queries, which is a bit more involved and is really intended for the purposes of the return columns.  But I would take the view approach as it is the most simple to implement.