Populating data in subforms
First a little background...
I have a master file, master.xsn, published to a sharepoint 2.0 form library that is being filled out as a request form. The request form is submited via a button in the form to another form library called 'secured' where it is stored for access by those who complete the various requests. This creates a completed copy of the origional master.xsn file as xxxxxx.xml where the file name is unique.
So far so good...this works like a charm. The file gets published to the 'secured' form library as an .xml file with with a unique name and the addional buttons used to access the subforms open the subforms properly.
Here's where the problem starts....
The .xml 'copy' of the master form is then opened, and a user clicks one of the buttons to open one of the subforms. I've tried using data connections to populate the fields of the subform from the form library containing the xml documents but nothing happens. The subform does open but I get no errors and the fields come up blank.
I can't seem to pass the data to the new subform from the xml document that is currently open. Remember, each .xml file has a unique name.
I also tried using multiple views but found it didn't meet my needs. As each subform is completed, the subform is emailed to the origonator of the master form. Multiple views will create unnecessary and confusing duplication that I'd rather not get involved with.
Thanks in advance!