BobLarson
I can live with the numbers it has been given , Thats what I Need :) , but i need to make the table Autonumber again as it is currently just Number !
edit: got the solution found on a different forum , look at the bottom for the Accepted solution...
Hi All
This is my first post so hope I get everything right :-)
Right i have three tables which are laid out as such
ID Number PK
Capacity_Band Number
Product Number
Price Number
previously the ID was a autonumber but this has...