Ok so here is my problem. I have a database with a table named items with a field named Item_ID. This field is set as auto increment. When I enter data into my database however it does not get the last number entered and add one to it, which I thought it would do.
It seems to remember the previous number used. Which is not good because in the meantime if I add and delete records as you do. Then look at the table I end up with gaps in the numers. i.e the Item_ID column will go 12, 13, 26,27, 190 ... you get what I mean.
Its just abit anoying cos to me its a waste. Is there a way to set-up the auto-increment to work like that ??
I have no idea if this is possible but I am just wondering.