one to many relationship list in SharePoint 2007 RRS feed

  • Question

  • I have 2 list - List A and List B-. List A contains States and List B contains Addresses of Employees (around 15,000 items in this list). When i add a new State in List A, the column "Active State" in List B should show Yes. And when i delete the state in List A, the Active State Column in List B should change to "NO". The issue is there are many records in List B with the same State, so when i add a new state - for ex. TX, all records in List B(around 20 items) with TX should show the "Active State" value as Yes. 

    I can modify the first record with TX value in List B but i cannot loop around and modify the rest of the items. Is there any way around to get this done?


    Wednesday, September 10, 2014 5:26 PM