https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/94792.aspxMon, 16 Dec 2013 06:06:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94792brice235i0https://www.infopathdev.com:443/forums/thread/94792.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94792<p>Hi there,</p> <p>I had a problem reporting on repeating table data in Sharepoint, so I created 2 form libraries - submission and processing.&nbsp; Both libraries use the same form template (content type).</p> <p>The user submits the form to the submission library which stores global content for the form suite - ie permit number, requestor details, job information - and generates a permit number based on the library ID.</p> <p>For each permit there are multiple sub activities.&nbsp; When the sub activity section is completed, the user submits the form to the second library in order to retain the common permit ID number and information that pertains to the overarching permit.&nbsp; Additional activities/child forms are produced by editing the base form in the submission library.</p> <p>This was working fine, until someone mentioned that occasionally the global information changes.&nbsp; Therefore, each child form would need to be edited.</p> <p>To solve this, I created a Form Load rule that sets the global fields to the value entered in the 1st (submission) library.&nbsp; Therefore we update the base form in the submission library, and when the child forms open, the&nbsp;form fields update. &nbsp;This works, however, the&nbsp;child&nbsp;forms must be opened for the Sharepoint columns to display updated information.</p> <p>Was wondering if anyone has a better idea.&nbsp; I haven&#39;t tried using form merge techniques, but perhaps this has potential?</p> <p>Thank you.</p>