Quote Originally Posted by InLaNoche View Post
It will not be a problem for me to create the fields for PortNumber and ModuleNumber, I was just curious if that would be a waste/inefficient/<insert other here>. I will do so and continue the testing.
One of the major things following the rules of database normalization does is educes data duplication. by having data entered in only a single place. It also dramatically reduces the number of fields that are a EMPTY.

This ha help: http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
and also: http://www.accessmvp.com/strive4peace/