I need to ask as many of you as possible to make suggestions for this 'problem'.
Imagine that you are looking at a typical screen with a grid and many records. You apply a record filter - it doesn't matter what the filter is - let's say it is all records with account code 6000. So the grid now is showing only those records where the account code is 6000.
Now you click the New button. You can probably guess what the issue is!! Our typical NewRow code runs and creates a new row in the data set - but if it doesn't match the filter, the row will not be visible and what will happen is that the first row will get highlighted and its details displayed. Users will get very confused by that I think. So my question is - what do you think is the correct response from the code??
We will know that the record is not in the grid so we could put up a message box and offer to:
- Remove the filter so that all rows are displayed
- Undo the New Row operation
- Modify the fields so that they fit the filter (that may be ambitious - and anyway as you edit the fields in the new row it might suddenly disappear!)
Or we could just turn the filter off as part of clicking New. That also might be unexpected - and possibly even annoying.
You may even have better ideas than any of these, which is why I really want to solicit your opinions before I code anything. I do realise that none of you have seen Filtering yet so you are having to use your imagination - but I think the issue is fairly simple - what I need is a profound solution!!
Thank you everyone.