Networking Structure in Access

[GameCharmer]

I decided that I would like to be able to lay my networking structure out in a nice Access Database so I can manage all of the connections easier than an Excel Sheet. I made the following tables

Rooms
(Room_ID, Room_Name, Room_Phone_ID, Room_Data_ID)

PhoneConnections
(Phone_ID, Phone_Panel_Name, Phone_Connection_Number, Phone_Extension)

NetConnections
(Net_ID, Net_Number, Net_POD, etc)

POD
(POD_ID, POD_Name, Pod_Max_Connections, POD_Master)

The Rooms table stores the ID for the net connection that is running to that room as well as the phone connections, so that table is taken care of. PhoneConnections is just info about the phone system. NetConnections has several more fields describing the connection type and the line material, dates, and other stuff but it not only links to a room, but to a POD. The POD table is what I need help with.

Basically, we decided to get an array of 8-port gigabit switches to remap our entire network with instead of the two large expensive switches that sit in one room. We just call the switches Pods, because the owners can understand it better.

I've seen the Switchboard in Access do this same thing, but I don't understand it. I want items in the POD table to be able to reference other items in the POD table. My ultimate goal is to start at the main switch that is connected to the router / servers, and see it's "children" switches. From there, I can click on a switch and see the sub switches. Then, Click on a switch to see a computer.

This could be done in the Switchboard system, considering that the max one switch can have is 7 connections (1 always goes back to the parent totaling 8) and the switchboard can only handle 8. I just don't know how to manipulate the code to get other info to display.

Any help would be greatly appreciated.

MAIN
|-"AMain"
| |-A1
| | |-Comp 1
| | |-Comp 2, etc
| |-A2
| | |-Comp 1
| | |-Comp 2
| | |A2-B
| | | |-Comp 1
| | | |-Comp 2
|
|-"BMain"
|-etc


EDIT---
Upon playing with 2007 more, I discovered that you can have more than 8 possible switchboard items.

I have the majority of the database done and I just need to populate data. I can post a link to an online copy if anyone would like to see what I'm working on.

 

[DCrake]

Simple Software Solutions

What you need to be looking at is Tree View Controls these can have as many parent nodes and child nodes as you described in your post.

 

[GameCharmer]

I think I came up with something that works...

http://www.gamecharmer.com/dl/Connections.zip

The form is Switches

I basically have a form that starts with the main switch. From there, I have two list boxes that list each attached switch or room (some switches can have multiple connections to one room or one room can be on multiple switches).

From there, you can click on a switch name and then the command button to travel down the list. I just got back into work so I'm going to be programming the room system in shortly. I eventually want to be able to lay out the entire building in Access.