Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I've got an external data source (SQL Server) and a Sharepoint Custom List that I want to join in a single view using the data view web part.

In theory this shouldn't be too hard, but I can't get it to work:

1) I created a linked source, using "Join" as the type.

2) I created a new DVWP, and then inserted a column from the first table as a Multiple Item View.

3) I then inserted a column from the second table as a "Joined Subview".

In the examples that I've seen online, at this point I'm supposed to be presented with a dialog that allows me to specify which columns in the two data sources are related. However, I never receive any such dialog, the second column is simply inserted, and the same row data repeats for every row from first table.

Am I missing something?

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

Talk about FRUSTRATING. The problem was simply that I only had one item in the Sharepoint list. After adding a second item to the list, I received the join dialog that allowed me to specify which columns to join on.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.