Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lalbatros
Yak Posting Veteran
69 Posts |
 Posted - 2007-12-14 : 07:41:46
|
| Hello,All of us have seen applications where it is possible to promote or demote items in an ordered list.I would like to implement such a thing for the records of a table.How would you suggest me to implement that, using Access for the user-interface and sql-server as database. The table should have up to about 1000 records.I imagined two basic ways of doing that:- implementing a linked list in a table, this would make list operations easy and efficient but user-interface more difficult- adding a sort-order field, this would make list operation less efficient (like "moving" half of the records) but would be easier for user-interface.Interrested to ear about your suggestions (or you code?),Thanks |
|
|
|
|
|
how-to: promoting / demoting records, user-interf.