Hello, I was just wondering if it was possible to alter a lookup grid such that it automatically filters by a certain criteria, i.e. displaying sales orders that only have a subtotal greater than $1000.  
 
Thanks!

Thanks for the reply! What I'm actually after is to modify the WORKORDER grid such that it ONLY shows open orders (I know there's already a button for it, but we never look at the closed orders and it would be more convenient to default to just the open orders.)
 
Since the corresponding field for this is MTWO.WIP.STATUS, and the value for an open order is "R" according to the grid, would I do:
 
AND | MTWO.WIP.STATUS | = | R
 
in the drill filter?
 
Thanks for your help.

WOW!!! I don't log on as admin much and didn't realize all those settings are there! Nice!