I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both List View WebParts, the connection is greyed out. How do I make this work?
There is very little information available on connecting WebParts on a web part page. This seems to be too advanced a topic for most of the end user resources. On the other hand, it's not a developer or IT Pro topic either.
The Administrator's Companion and the "SharePoint 2007 User's Guide" by Seth Bates both have one page on the topic. Office Online, Connect Web Parts, is not complete.
Update 1/29/2010: Rereading my question and Brian's answer, I've given him the credit. This question really has two parts and he did help me get my web part connection working. The best reference for WebPart Connections is still open, though I'll copy it into a new question.