Ok, I have been reading all sorts of posts and such for about a week and still have no come up with any concrete answers.
I cannot properly join lists in SP 07. I say properly because I never get the option to select a field to associate one with the other.
I select "Create new linked data source" from Data Source Library; Pane opens; Left Click "Configure Linked Data Source"; Add 4 to 5 lists from "Current Site"; Select Next; Select Join option but Next is greyed out. Is this supposed to be greyed out because
they are lists? Can lists be joined? I see alot of examples on joining databases and excel pages but not too many on lists.
If I select next from the last point, open the linked sources and select my newly created linked source and click to show data, I can see all of the information in there. Problem is I don't believe the lists are really joined by anything since I never received an
option for it.
I also have been reading up on joined subviews but I never receive an option for joined subview. Is the joined subview the way to go for lists? If so how?
I know these boards are fairly active and any information or help would be greatly appreciated.
View Complete Post