I want to create a dataview (ultimately a joined subview) from a joined Database Connection and a SharePoint list. I have done this in the past with no issues.
Recently the issue is that I am unable to link the two data sources. I can show the data from both sources individually no issues. I can choose the option to link to another data source. I can select the two sources and then select
join, again without issue.
When I would expect the window to select data fields to join on, it doesn't appear. When I select finish I am presented all of the fields for the SharePoint list, for the SQL data source I am only presented with "Rows".
Not sure why I am having this issue...but I have had this issue for months. I have been getting around it by utilizing a prebuilt page that works and just changing the SQL in the query.