Linking cells of one sharepoint list to another
Is it possible to link a cell in one Sharepoint list to a cell in another Sharepoint List. I have the same column (license #) in multiple lists. So I'd like to have the data entered on one list but the link the other lists to the appropriate cell on that master list so that when the data is updated, it only needs to be updated in one place. Is this possible and if so, how is it done. I know that I can put a hyperlink in a cell to a list on Sharepoint but I'd like to link in way that the data automatically updates.
July 12th, 2010 9:28pm

Two ways to make it happen: 1. implement Event Handler - ItemUpdated event, after updated List A, try update List B (license #). 2. like Mike Walsh hinted, use lookup fields. There are two scenarios for these two method: Scenario 1: List A is almost identical with List B, but for different purpose - e.g. List A can be viewed by internal users, List B can by viewed external users. Scenario 2: List A and List B are normalized data and need joined together for overview - e.g. List A is Customer list, List B is Order list. You should choose your method depending on your situation. -Bin
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2010 6:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics