Access - auto-sequence number when deleting field mid point.

[JamesR]

This maybe a strange one for you



At present I am running Revit Architecture with DBLink to access to edit fields for shelving etc.

What i am doing is fitting out warehouses with 600+ shelving units and they are all numbered.

These numbers are tagged in the drawing.

What I am hoping to do is export the data to access (completed) then amend any changes within access.

Normally, we would put say 600 shelving units on a drawing all tagged 1-600. But then the client may want to delete shelving unit 321.

Leaving the drawing with all shelving units tagged 1-320,322-600.

How would i go about it so access renumbers all data after the deleted field (ie number 321)?

Thank you in advance.

[alansidman]

you would have to create a make table query using all fields except the existing ID field. Then in your new table, in design view, create a field that is the new ID field and have it autonumber. Save the new table. Delete your old table.

Alan

[JamesR]

OMG!

Thank you, I have been trying to do it a lot harder way.