Network Device Inventory Database

I am trying to create a database to keep track of static IP addresses
associated to devices. This has also got to store the location of the device,
the type of device, the contact person, the vendor, device make etc.
I am having problems when it comes to the IP address. Part 1 of the IP
address is standard, Part 2 relates to the location of the device, Part 3
relates to the type of device, and Part 4 is for the actual device.

I have started to break the IP address into 4 parts and have the relevant
parts located in the location table, device type table etc.

My main problem is how will it know to increment Part 3 inrelation to Part 2
when the max of Part 4 has been reached, and to get Part 4 to reset and start
at 1.

Can someone please help!

You should look into using the DMax function.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html


"Cider Baby" Cider wrote in message
...
I am trying to create a database to keep track of static IP addresses
associated to devices. This has also got to store the location of the
device,
the type of device, the contact person, the vendor, device make etc.
I am having problems when it comes to the IP address. Part 1 of the IP
address is standard, Part 2 relates to the location of the device, Part 3
relates to the type of device, and Part 4 is for the actual device.

I have started to break the IP address into 4 parts and have the relevant
parts located in the location table, device type table etc.

My main problem is how will it know to increment Part 3 inrelation to Part
2
when the max of Part 4 has been reached, and to get Part 4 to reset and
start
at 1.

Can someone please help!