I am trying to implement a grid which resembles the listbox. The main feature I want is to allow user to select a few records and move the records up or down in the table. I keep a sequence number in the table to sequence the records. It works fine if I am using non-buffered view and tables. But when I use view with table buffering, VFP stops me by saying view with buffering cannot be indexed.

Can someone suggest a way to overcome this? If there is no way of indexing the view, is there any way I can reorder my items on the grid without using index?

Because I am on buffering mode, I need to do a 'COPY TO' statement to get data from the memory before I issue an SQL statement to collect the records that are flagged. Is there a better way?

This thing is taking too much of my project time and it is killing me. Please save me... I guess that's why MS never implements a moverbar-listbox that accepts input from fields.

Any help will be appreciated. Thank you.