I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are hosted on the server in the server list and which servers host which applications in the applications list. This process is becoming difficult to maintain. What I want to do is have only one of lists have a lookup column in which the user manually selects the server or application and have the other list automagically have a reverse lookup column and populate with the server name column or application name column.
Thank you in advance for any help.