sammyfaisal
asked on
How to set the Data connection in InfoPath to a relative address with SharePoint Lists?
Hi,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
http://alancoulter.blogspot.com/2007/11/migrating-infopath-forms-over-to-moss.html