Link two sharepoint columns together

Question

I have two lists in SharePoint. One is a Server/Device list, the other is an IP Address list. I would like to pre-populate the IP Address list, and then, on the server/device list select the IP address(s) assigned to that server.

After that, I'd like the "Device" column on the IP Address list to reflect which device is using it.

Is it possible to do this without having to manually set the device on the IP Address list? I want it to automatically update based upon what the row device has set.

Answer 1

• Step 1 - Use lookup in Device list that looks up IPs from IP Address list.

• Step 2 - Create a Event Handler Code for Device List that listens to the item updated event

  public override void ItemUpdated(SPItemEventProperties properties)

• Step 3 - When list item in Device List has updated, your event handler (created in step 2) will assign that value to the matched item in IP Address List

James