>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


Tony,

If you have an order set on that table, the blank one will be moved to the top.

Ed