Bound Column 0 silly problem

[PLiNk]

I'm still not exactly sure how this occured so correct me if i have misspelled something,

What happened was that i had 20 people listedwith their own number from one to 20.
20 posts with dual listboxes

Then I added record labeled and number 10 in the list into the other listbox and with a not-so-clever-but working query deleted number 10 in the first.

Then I added the post 19 into the other field but strangely in the other listbox 18 appeared.

Then i added the post 06 from the first listbox and 06 appeared.

Then I added 17 and 15 appeared

Then i added 14 and 11 appeared.

then i added 15 and nothing appeared
in the other listbox

What was going on!

Then i changed the bound column from 0 to 1
telling it to use the playerkey instead of something else i didn't figure out what was.
Turns out the program counts the records and uses that number by default (in delete queries and other). When a record disappears this changes the number for every record above the number it removes, so that post number 19 was no longer 19 in the list, but say 15 if i had removed 4 records in the first listbox.

Almost made me start smoking again it did.

regards
Stan Dandtjes