I have 2 tables, and I guess I am looking for advice on the best way to store and manage the data. I have a table with the list of all desk/office/room network ports. my other table is a list of the Network switches. I would prefer not to have a set number of fields for the switch table (1-50?) for each port. For now what I have done is stored the switch name and the port name in the first table (a field for each). When I get reports I can do a query to find the switch name and show those network jacks based on the info in that table.

Where things go down hill is when we have switches plugged to switches. And in these cases, the direction of these connections should probably be defined. Would it be better to create a text field and use a delimiter for storing the port info on the switch table? Does anyone have a better idea?