How to join two SharePoint lists with inner join functionality


SPRIDER

Create two SharePoint lists

a)     Customer (Title)

b)    Orders (Title, and Customer)

Here are my lists –

Open the your site using SharePoint Designer (SPD), and add a new page under site pages library

In SPD, go to Data Sources. In the window that appears; create a new Linked source as shown below:

Click on “Configure Linked Source” and go ahead and add both “Customers” and “Orders” and click “Next”

Make sure that you choose to join the contents of the two data sources as shown below

Give it a meaningful name in the “General” tab.

Now Insert an Empty Data View in your page and put the cursor on your data view

Now from the “Data Source Details” pane, select Title from Customer List. And choose – Insert Selected Field as “Multiple Item View” as shown below:

After this your page will look like this

Now add a column to the…

Ver la entrada original 58 palabras más

Anuncios

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s