<font face='Arial'>Hi all,

Not sure how to go about this. My client has a price list, which I am inserting into one big table in Access. They require the ability to move the positions of the content in the price list. Ideally (in the Admin section of the site) I would like to have each inputs' position in the recordset changeable.

Any ideas? TIA,

//Dave
NOTE: ASP (VB), Access DB
</font id='Arial'>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>My client has a price list, which I am inserting into one big table in Access. They require the ability to move the positions of the content in the price list <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

plz explain that in a bit more detail for my sake <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Regards,
Dave

[DWMX 2004] | [FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]

If I understand correctly, this might help:

I have created news article tools that several of my sites use. In order to allow them to control the order of how these are displayed, I simply added an 'Order' field which consists of a 'sort number' that the user adds in the admin screen, and then I order my recordset on the page by that field.

Here is a screenshot of that in action - should give you an idea what I am talking about:

<img src="www.conncreativemedia.com/services/documents/sort_order.jpg" border=0>

<b>Connman21</b>
www.conncreativemedia.com
<b>DEVELOPMENT SETUP</b>
DW MX Studio
Web Server: IIS5
DB: Access2000/SQL2000
OS: XP Pro
Language: ASP/VB

Edited by - connman21 on 14 Jan 2004 21:57:56