I have a database that keeps track of computer system information. I have a record for each system (one per room). Within this system there are a number of different computer devices and I want to track settings such as IP addresses subnet masks and other network type information.
I have a table called “Systems” and I’m using tabs to separate the different devices within a system. Within each separate tab do I need to create a unique field for each piece of information or is there a more efficient way to do this? For example:
the first field would be device one IP address
the second field would be device one subnet mask
The third field would be device one preferred DNS
The fourth field would be device one IP address
The fifth field would be device one subnet mask
The sixth field would be device one preferred DNS
Etc.
Seems like I’m missing something and there might be a more efficient way. Thank you for any help.
