Hi Guys,
I hope everyone is doing great. I am pretty new to Access 2013 and database design. I am trying to consolidate all of our excel sheets that we use to keep track of assets. Cell phones, Cell phone plans, Network equipment, computer equipment, cameras, etc. There are a bunch of them. I have started to use the Desktop Assets Template. I have been able to customize it for the most part for what I need but I am struggling on one thing that I hope someone can help me with.
We have servers as an asset. There are servers that have multiple IP addresses. I wasn't sure what is the best way to do this. in my excel file I just created a new line even though it was the same server name. something like below.
Server1 IP Address
Server1 IP Address
Server1 IP Address
Its not the best way to keep track of things but this works for me in excel when we need to sort by IP Address. Moving to Access I know this is probably not the best way to do things? I was thinking that I would just create a new field called IP address 1, IP Address 2, IP Address 3 etc. If I do it that way then it really screws me up when I look at the data in datasheet view. its a little difficult to sort by IP address. Does anyone have any suggestions? I have attached my relationship view below not so show the relationships but so that you can see the tables that I have and what fields I am tracking. Any help would be greatly appreciated.