Hi,
I am having some basic problems with access. Essentially I am numbering "shelving" from 1-600+ which are being imported into access from an architectural program.
I solved one problem of renumbering them if i delete some halfway through, but im coming up to another problem now.
My architectural program auto increments and adds the primary key in ascending order as the shelving units are placed in the drawing. The problem is the order they go in the drawing will not be the numerical order of them by their "mark".
So, when i export the drawing to access the DB is auto sorting my shelving by the Primary Key, so when i delete some and renumber in the DB it is all over the place as it renumbers them (via a new "autonumber" field) by ascending primary key order.
is there a way i can stop this?