How do you plan to store the order field? Is not it already in the table? Why use another field for that?
>>SQLEXEC ("select * from DATA", "cTemp")
>>thisform.grid1.recordsource = "cTemp"
>
>Not being an SQL regular, would:
>
>
SQLEXEC("select *, 0 as order from DATA", "cTemp")
>
>do the trick? Then populate Order manually when you get it back?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.