Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The title might be a litle confusing, but I dont know how to explain it better. Here is my problem: I have three lists - LIST1, LIST2, LIST3.

LIST1 and LIST2 are not interesting. LSIT3 contains all the records from LIST1 and LIST2 and some other records. LIST3 should show all the records that are not updated within the last 5 days. LIST3 should also take in consideration, when some record is updated in LIST1 or LIST2 the last 5 days, it should not be displayed.

In other words LIST3 should show all records that: - are not modified the last 5 days in LIST3 AND are not modified the last 5 days in LIST2 AND are not modified the last 5 days in LIST1

share|improve this question
    
Sorry, i was so happy to finish this post, that i forgot that thank all those that will (hope so) try to help me:) –  Boris May 9 '11 at 15:28
    
I'm a bit confused about your question - title asks something about updating column values yet the body of your question seems to be asking about how to structure a view? –  James Love May 9 '11 at 15:34
    
Yes, because i was thinking how the update the MODIFIED column in LIST3 to be equal to the newest MODIFIED column in LIST1 or LIST2. –  Boris May 9 '11 at 15:51
    
So what is your question? You already have all three lists? Are items tied together somehow across lists? –  Kit Menke May 9 '11 at 16:30
1  
Fix question so it is clearer what the problem is. Also I cant see why you would want tree lists; it looks like 3 views on one list would do the same –  Anders Rask May 9 '11 at 18:48
show 3 more comments

1 Answer

Your question is a bit vague but there is a solution that I think might work for you.

Create an Event Receiver and attach it to List1 and List2 so that when they are updated they also update the appropriate item in List3. With that in place, your views should work as expected in List3.

share|improve this answer
    
Event Receiver are created with Visual Studio right? –  Boris May 11 '11 at 8:54
    
Yes creating an event receiver requires writing some code in Visual Studio and deploying it to the server. –  Kit Menke May 11 '11 at 13:38
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.