How to Link Tables in Sharepoint
The Microsoft Sharepoint services server includes a designer called "Office SharePoint Designer," so you can customize the data stores on the Sharepoint server. You must link Sharepoint database tables to query and manipulate data from several tables. The Sharepoint designer lets you link tables without the need to know SQL code or joining structures.
Other People Are Reading
Instructions
-
-
1
Open the Sharepoint Designer software on your desktop. Click "Data Source Library" in the "Task Panes" menu panel. Click "Create a new Linked Source" to open the linking wizard for your Sharepoint server.
-
2
Click "Configure Linked Source." In the left side of the window is a list of table sources. Click each data source you want to link, and click the "Add" button. Notice the table moves from the left to the right side of the window labeled "Selected Data Sources." After you choose each source, click "Next."
-
-
3
Click "Join the contents of the data sources by using the Data Source Details to insert data views and joined subviews" in the next window. Click "Next," then review the joined data and click "Finish." A window opens that lists the joined data sources.
-
4
Double-click one of the sources to open a list of data. Review the data and its link to the other tables. For instance, linking "orders" and "customers" should show a list of customers and their associated orders.
-
1
