>I have a set of grids on a pageframe. I am trying to sort and make available records based upon any one of 6 categories selected by clicking on a set of buttons.
>
>I have used the recordsource and recordsourcetype fields to set an sql statement into a cursor, works fine but I cannot add/edit the resulting information.
>
>I then tried to set focus on the loading of the grid, but while setting the recordsource to the table involved allows adding and editing, it does not seem to do any sorting or selecting at all - resulting in all records being displayed.
>
>I am trying to show a limited number of records and provide the ability to add/edit the records displayed.
>
>Any Ideas?

To show a limited number of records, stick with a view or a cursor generated from a SQL statement. Make the view name or the resulting cursor the record source for the grid. You can make a view editable......and you can make a cursor editable with USE and the AGAIN IN 0 clause and you can index whatever columns you wish to create the desired order.

Steve