Is there a way to create a search form against fields that do not exist on the grid.  Example:

• Order header
• Order detail lines (include ITEM column)

Grid only includes columns from Order Header, but we need to include search form to filter only Orders that contain item number in it’s details.

SQL would be something like:

select orderNumber, orderStatus

from orderHeader

where orderNumber in (select detailNumber from orderDetail where  detailItem like [search_item] or [search item] = ‘ ‘)