Setting priority

[samonwalkabout]

I have a database of projects and want to set a priority to each record. I need the exisiting records to drop down a priority level if a new Priority 1 is entered, but also need to be able to increase and decrease priority levels at any point. I can use the update method and open the form on the record im changing and change its priority. No worries

but the tough bit is........for ease of use (and as i cant have duplicate values) i need it to change the other record at the same time.

What i would love is a form with a list box of projects in order, where i can click an up of down button to move projects priority. (like in a report wizard where you alter the order of fields displayed) Anyone know how its done?

 

[directormac]

I haven't had a chance to try this yet, but what about a main form with up and down buttons and a subform listing the info you want to see in a continuous-form listing? Highlight a record on the subform, click a button, have the OnClick property adjust everyone's priority and refresh the display.

I'll bet someone on these board has set this up before...

--Intrigued Mac

 

[samonwalkabout]

Thats what i need...any chance of a demo

 

[directormac]

Something like this VERY quick-n-dirty example. I'm sure the gurus hereabouts have much more elegant solutions, but this will get you started on designing your own.

You may also want to search the archives here, I'm sure somone has u/l'd a better way at some point.

--Harried Mac

 

[samonwalkabout]

Thanks

Thanks for that Demo i have a better idea of how to do it now. Just need to figure out a way of keeping the focus of the movment on one record without having to keep selecting it to move.

 

[directormac]

Look around for info on bookmarks, as well as perhaps multi-select list boxes--there's all sorts of improvements to be made on that basic idea.

--Progress Mac