I have a grid whose RecordSourceType = 1 - Alias...
The records are sorted on a Character field in the table...
I use an "ADD" command button to add essentially blank records...
I use the following command in the click event to add a record and link it back to the parent table.
insert into XXX (parent) values (parent.id)

This works great...except when I click the button multiple times...
the first blank record appears at the bottom of all records and
the rest of the blank records appear at the top of all records.

Any ideas why or how to fix???

Thanks