I know it's a common SharePoint problem. I want to accumulate two SharePoint lists on MOSS 2007. One is a calendar list and the second a custom list with a date column. I want both in another list. The only function the target list must have is to show the items of both lists. There mustn't be a function for creating new items on this list. The view should be near realtime.
What should I use?