Hopefully a quick question...

I have a grid bound to columns in a view. The view is sorted by a line item number - a column on the table and view. There is a delete and an add button to manage the items in this grid. I would like to specify where on the grid the item that is being added by using a line item number. For example, if I have a line with a number of 1 and a line with a number of 3 on the grid, if I add one with a number of 2, I would like it to insert between lines 1 and 3. Right now, it just puts it on the end when I perform the insert. After the records are saved and the form/grid is reopened, the records are sorted fine. What am I missing?

Thanks,

Randy