Hello,
Ive got a product table with a ProductID which is an autonumber. As this increments itself - When a product is deleted that prodID disappears and it is not replaced so when a product is added it carries on with the autonumber.
Example:
Last ProductID used is 80.
ProductID 80 is deleted so when a new Product is entered, it should enter onto ProductID 80 but mines goes onto 81.
So when you look at the table there is ProductID 79 then 81.
How can i code this so that it looks at the previous productID and then increments by 1 so there is no numbers missing in between when a Product is deleted..
Thanks..