Thanks for the info on this. I probably did not explain it well... the tables (BoxNo and SwitchList) is set up as such:
BoxNo
ID -number
BoxNumber - text
OfficeNumber - text
SwitchIP -text
SwitchPort -number

SwitchList
SwitchIP - text
Ports = number

The number of ports on a switch vary from 24 to 50+, and I did not want to make 64 fields that may never be used. So instead I stored the Port info as shown on the box numbers. Well, some switches will connect to other switches, and so that info cannot be stored in such a way. I was thinking that I could use a text array (csv) to store the port info and parse it later when needed (thus storing it with the switches instead of the boxnumbers).

Would this be the best idea? Or should I bite the bullet and just create the fields?