Prepared By Rajesh Pillai, Bangalore India.----------------------------------------------------------------------------Joints between SharePoint Lists: As a first step let us create two lists in MOSSa) Customers (Title)
b) Orders (Title, and a lookup value called 'Customer' - which, you guessed it right, is a lookup on the Customer.Title SPColumn).Here are my lists – Customer listOrders List Cool. Now Open the site in SharePoint Designer, and add a new ASPX - Untitled_1.aspx (that's the default name). Give any name.1. In SPD, go to Data View --> Manage Data Sources2. In the window that appears on the right, create a new Linked source as shown below: 3.Click on "Configure Linked Source" and go ahead and add both "Customers" and "Orders" and click "NEXT"4. Make sure that you choose to Join the contents of the two data sources as shown below - 5. Give it a meaningful name such as "My Customer-Orders" in the "General" tab.6. Superb, now while in the <form> tag in your ASPX, click on Data View --> Insert Data View, your UI should now say "Current Data Source – My Customer - Orders" - "next insert fields to create a view".7. Now from the "Data Source Details" pane, select Customers.Title. and choose - Insert Selected Field as "Multiple Item View" as shown below: 8. Now your aspx page looks like this 9. Now place the cursor in front a particular value - Say "Lee Beyer", and now in the Data Source Details Pane, Select Orders --> Title, and choose to insert as "Joined SubView" like shown below: 10 .Do the join as followed 11. That’s all. Format the page as you like my final page looks like this Thanks,Rajesh Pillai
Rajesh Pillai