>>How do you plan to store the order field? Is not it already in the table? Why use another field for that?

>Considering I haven't been able to look at his entire app, I don't know what "A numeric identifier" does in his table. If it would work here, he can use it, but I'm not sure why he would have asked another question then.

>Maybe I'm different, Vlad, but I'd rather address his first general question instead of every aspect of his specific scernario.

OK. Lets just say my database has the following layout:

name char(10)
order numeric(2)

Some data could be:

name order
Erik 1
Mike 2
Vlad 3

I can get this by using SQLEXEC("SELECT * FROM DATA", "cTemp")
I set the recordsource from the grid to cTemp. When I select the
2nd row and press 'up', I'd need the following in the grid:

name order
Mike 1
Erik 2
Vlad 3

I could change te value in the cursor, but how do i set the
order the cursur cTemp???

Erik