#Checkbox and #Auto-Number

Hi Jeff,
1.
The 'auto number' option simply adds a column to the tablegrid so you can easily identify where you are (ie "I'm on row 67");  basically, it's just a sequence number. 
Note that when you resort the tablegrid, the auto numbers don't get re-sorted - that's the whole point.
2.
The 'checkbox' option allows you to select random rows from the tablegrid that you might then want to perform some sort of action on ('filter' by rows that have been 'checked', export 'checked' rows to Excel etc etc or, as in the attached example, you use the checkbox to select all the rows that you want to copy into a Bill of Materials).
Be aware that neither the 'auto number' nor the 'checkbox' forms any part of the actual data structure so you won't see them if you examine the data using SQLite or something like that - they're just temporary while the program is running.
If anything's not clear, just shout.
Derek.

Hi,
A couple of options to have a go at (see the attachment for a couple).
The first example uses a checkbox to filter the data (just check random rows of data and then click the 'filter by checkbox').  When you're finished working on the list of filtered rows, just click the 'filter by checkbox' again.
The second example takes a different approach (and doesn't actually use a checkbox but uses arrow indicators as being a bit more intuitive for the end-user).
There are other options as well - probably a case of picking the one that best suits your project and/or your users.
Derek.

Hi Derek

Ive taken the time to study both options and extrapulated some of the ideas, but my problem is that I need to transfer from one table to another.
I've made a little demo of what I am looking for but faced with some sql ISSUES.

I also think there is a question of ID from my customer table that comes into effect, but I dont have enough knowledge or forsite know if that applies.

Here is a small demo of where I am at, and the issue I am getting, before I can continue puzzling out my next steps.