asset tags

[itsalesguru]

I want to keep track of IT assets in 7 different departments. But want to make it a bit user friendly. like to have a form that end user can go to and input the number of items, let say 20, then their department let say HR, and type the type of assets let say PC.
I have my tables, ASSETtbl, INVENTORYtbl, Departmenttbl. Inventorytbl essentially has all the details such as item serial number, user,..

I am stuck on the first part of how automate the generation of asset tages that are sequential numbers.

 

[Rabbie]

You could use the DMAX function to find the current highest used value and then add 1 to it.

 

[itsalesguru]

thank you, i would defineltly try that