>I have a Grid in a form that allows users to add rows. To add a new row, my code fires an append blank. Unfortunately, all new records appear at the bottom of the grid and not index order. Is there a way to reorder the Grid on the fly?

Andy,

I believe all you'll need to do is to put in some code into the insert trigger, or in you field default value (This should work for both tables and views), to load the field with the next desired value.

Rick Liebespach