That might work.

I would test it before creating any forms.

Start by entering all the data for two linked switches and all the devices connected to them. Enter it directly into the tables. A good set of test data will have at least two records in every table. Now see if you can create some queries and reports to present the data as needed. If you can get the data out the way you need it then it is time to create forms.

Quote Originally Posted by InLaNoche View Post
.... I feel that I am close to what I need, but would like to remove the possibility of incorrect data entry....
It is very difficult to prevent all possible data entry mistakes. A good database design/scheme also helps recover from data entry mistakes. A key to this would be never using data, for example IP address, as a primary key and/or foreign keys. Always use a system generated primary key. In Access use the autor data type.