Gossamer Forum
Home : Products : DBMan : Customization :

Automatic priority field update

Quote Reply
Automatic priority field update
I have a "Priority" field in the database containing number 1-n (n being number of records in db)

How can I allow a registered user (there's only 4 for this program) to change the Priority field of a record and have DBMan go through the database incrementing all Priority fields >= that number just set? Of course they will probably move the priorty down so it would have to decrement every Priorty field down to "n" also.

Any suggestions would be appreciated .............
Subject Author Views Date
Thread Automatic priority field update barnefr 1586 Jul 17, 2002, 10:13 AM
Post Post deleted by barnefr
barnefr 1493 Jul 21, 2002, 6:52 PM
Thread Re: [barnefr] Automatic priority field update
barnefr 1474 Jul 21, 2002, 8:10 PM
Post Re: [barnefr] Automatic priority field update
LoisC 1474 Jul 22, 2002, 12:18 PM