I have two lists on SharePoint imported through excel:
- System (speadsheet -- contains 10 columns)
- Server Inventory (speadsheet -- contains 14 columns)
I would like to link the two together. For example, in the system list, one of the columns displays the server names. I would like find out information about that particular server that is stored in the server inventory. I could do this with the lookup column no problem. However, System contains unique server name values. But Server Inventory has many items with the same server name. With the lookup column it only displays one of the findings when there are altogether 4 items that have the server name. Is there any way to solve this problem?
Is there any way SharePoint could show me the filtered Server Inventory list when I click on one of the servers in System list?
Any help would be much appreciated. SharePoint 2010