Hi Nick,

Here are 2 GridView 'quickies':

- When using the QueryString function to ask for runtime entry of text (item numbers, customers, etc) and comparing to your data, matching has to be exact, including leading and trailing spaces. Change your filter to 'trim' spaces from your data field value:
Trim({Item number}) = QueryString("Enter the item number")

- If you refresh a View with a filter and get a blank screen as a result, you can toggle the filter button off from the toolbar. This will load the entire database into your view without any filters. If the file is large then this could take some time to refresh, so use prudence if you do this. And remember to turn the filter toggle back on when you want to determine your filter is working.

And one other note. If you are using the runtime query for item numbers to search for all records equal to one or more codes in a file such as OrderEntry or SalesAnalysis (which can be very large files), consider using a link rather than a runtime query; performance is significantly faster. So instead of having a single view based on SalesAnalysis transactions and a query asking for the item code, include a second view on the item master file and link it to the transaction view (by item number) that you already have - and save as a workspace. Then you can double-click to get the same list much faster. And also you can multi-select items from the main list and do a query for multiple item codes at once.