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
where orderNumber in (select detailNumber from orderDetail where detailItem like [search_item] or [search item] = ‘ ‘)
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?