Hi Guys

I am trying to find a way to sort out records in table based on sequence

Table A
Fields
Select [yes/No]
Product [text]
Sequence [Number]

example

SELECT | PRODUCT | SEQUENCE
[ ]-------- ABC---------- 1
[ ]---------DEF---------- 2
[ ]---------IJK----------- 3
[ ]---------LMN---------- 4
[x]---------OPQ---------- 5
[x]---------ABC---------- 6

Task to acheive

Those Products which are select with checkbox can be move to any place ( for example move sequence 5,6 after 2) and then rearrange order.

SELECT | PRODUCT | SEQUENCE
[ ]-------- ABC---------- 1
[ ]---------DEF---------- 2
[x]---------OPQ---------- 3
[x]---------ABC---------- 4
[ ]---------IJK----------- 5
[ ]---------LMN---------- 6


Any help or suggestion

Thanks

I'm doing something similar for our production schedule database.

My approach is to use a temporary table with an autonumber field to generate a "SortID" for my schedule table. The SortID is a regular number field in the schedule table, which was copied from the temp table's autonumber field.

This puts all new entries at the bottom of the list in the schedule table.

Then to move an entry up or down, the production supervisor selects the item they want to move and then clicks an up or down arrow to move the item.

Clicking the arrow swaps the SortID of the selected record with the SortID of the record above (or below) depending on which way they want it to move.

Hope this helps.

8^D

I've done that by using similar way :)

But I had a problem when sorting rows on the fly but it is resolved now.

I had issue with sorting rows in a order. All the selected item must be inserted where you want to insert them but push rest of selected row down or row up with out changing orders or sequence b/c production want to prioritise only few item without effecting others.