Insert number into sort field.

HI,

I have a iQuery drag and drop script that works really well to re-order the rows in a database table, so I would like to use it for the "items" table management, to update the location of catalog items.

The only issue at the moment is that:
When entering a new record into the items table, I would like the next higher number in the sort field entered automatically.

I am doing it manually at the moment.

To further complicate the issue, I am using the "Multiple Record Inserts" behaviour.

It would be brilliant if this can be done

I have figured out a method of inserting the next higher number from the items table sort field data into the insert form field "sort".

I set up a separate recordset with the following select query:
SELECT MAX(sort) +1 FROM items

And then bound the new recordset data to the insert form field "sort"

If it was a single record insert, it would be OK.
Unfortunately it puts the same number into all of the multiple record inserts repeated fields.

Therefore I need it to increment based on the number of repeat regions in the multiple insert records behavior.

Anny ideas on achieving the above would be appreciated.

send a copy of your page so I can take a look at the code to figure something out.