How to set the Data connection in InfoPath to a relative address with SharePoint Lists?

Posted on 2009-04-26
Last Modified: 2013-11-05
I'm trying to create a site on SharePoint 2007 that contains an InfoPath 2007 form, in the form there is a section that receive data from a List in the same site on sharepoint, the thing is I want to save that site as a template and create more sites based on it, but the problem is that when you create a new site, the form on the new site get's it's data from the original list on the template website, as the address for the data connection is pointing there. now is there a way to make that address relative or something like that so when I create a new site it point to the list on the same new site instead of pointing to the original?
Question by:sammyfaisal
    LVL 3

    Expert Comment

    LVL 6

    Accepted Solution

    LVL 1

    Author Comment

    Thanks Guys, biziosh way with Relininking the documents will update only existing documents, it will not fix the links automatically when you create a new document after creating a new site from the template, I haven't tried what's ramuar link is suggesting, although I think it should work, but I was also hoping to avoid using SQL in the process.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now