C# and access trying to order and change order -

i have access database manipulate though c# program. trying order of items satisfy conditions.and able change order.

my idea copy unique key in field order field , have button moves , button moves down.is right way go ?

a separate column in table called order example makes sense, allowing user re-order items , save database. maybe drag/drop or re-ordering bit less clunky buttons, guess depends if c# application winforms, wpf, web, etc. how easy is.