http://www.endusersharepoint.com/STP/ SharePoint QA en Mon, 20 Jul 2009 23:51:14 +0000 http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8556 Mon, 20 Jul 2009 17:54:25 +0000 ihmunro 8556@http://www.endusersharepoint.com/STP/ <p>Hi Illegal Operation</p> <p>Thanks - Nancy managed to follow it, but mine is not working.</p> <p>Not sure where to start - should I be on the default.aspx page?</p> <p>I get the joins done, but when I got to show data, the only fields that come back are called rows for both, which does not give me the options you have identified.</p> <p>Anything else you can suggest would be appreciated.</p> <p>Iain </p> http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8531 Fri, 17 Jul 2009 22:59:07 +0000 NancyCentury 8531@http://www.endusersharepoint.com/STP/ <p>I just did this today as a matter of fact. It's a pretty awesome solution. </p> http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8529 Fri, 17 Jul 2009 19:00:19 +0000 ihmunro 8529@http://www.endusersharepoint.com/STP/ <p>Mnay Thanks to both of you.</p> <p>I will let you know how it goes.</p> <p>Iain </p> http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8519 Fri, 17 Jul 2009 10:26:10 +0000 illegal operation 8519@http://www.endusersharepoint.com/STP/ <p>I've done this a few times, it took some getting use too. </p> <p>Hopefully I don't leave out a step, but here goes</p> <p>1. ON the datasource library tab, select Linked Sources<br /> 2. Select 'Create new Linked Source'<br /> 3. The Data Source Properties window should appear, Click the Configure linked sources button.<br /> 4. The link data sources window should now appear, add the 2 lists that you want to join.<br /> 5. Once you finished, SPD should take you too the Data Source Details screen.<br /> 6. Insert the records from the main list to your page.<br /> 7. Now scroll down to your other list, and select the field you want to add<br /> 8. Click on the 'Insert Selected Fields As' dropdown and select Formatted&gt;Joined Item<br /> 9. The Join Sub view window appears. Select which 2 fields are the 'keys' used for the joining.<br /> 10. click OK.<br /> 11. The field should appear on your page and should be joined by the 2 fields your selected.</p> <p>I think that's it, hopefully I didn't forget a step </p> http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8513 Thu, 16 Jul 2009 21:25:23 +0000 EndUserSharePoint 8513@http://www.endusersharepoint.com/STP/ <p>Iain - Laura is putting together a live online workshop with this exact solution. Keep an eye out for the announcement. -- Mark </p> http://www.endusersharepoint.com/STP/topic/dvwp-question#post-8477 Wed, 15 Jul 2009 20:02:39 +0000 ihmunro 8477@http://www.endusersharepoint.com/STP/ <p>Evening</p> <p>Earlier I asked a question with regards uing the DVWP for bringing bakc data relating to original information entered.</p> <p>For example, I have a list that captures a serial number and description.</p> <p>In another list using a lookup info already on this site, I have the serial number as the key. What I need to be able to do is bring back the description on the page as well.</p> <p>I asked if the DVWP was the right way to go and got a resounding ys, but as I work through trying to do this, I cannot figure out how it is supposed to work.</p> <p>Laura - would this be a good screencast to do ?</p> <p>Iain </p>