First of All, Thank you for your time, Hilary, really appreciate it.
Q. Where is your first form storing its data?
A. SharePoint 2007
For example, the first form has a unique identifier called: DNumber.
When the first form (lets call the first form , the CENTRAL form) is submitted, the value in this field gets submitted to Sharepoint List.
All other forms have a similar field that will have this unique value in a field, just that the fieldname will be different.
What I want to be able to do is that, this field (the unique identifier) should autopopulate in all other forms when they are opened from the first form.
How can I do that?
I had tried to set it up in a way that worked but, with a catch. So when the CENTRAL form opens it stores 2 pieces of information in hidden fields, username and substring(now(),1,16)
When the Form1 Button is clicked on the CENTRAL form, it opens Form 1 and fetches the DNumber from the sharepoint list, filtered by the username and timestamp obtained by substring(now(),1,16. The problem with this method is that sometimes the username and/or the timestamp function does not work if the computer is slow or sharepoint server is slow and then autopopulation does not work. (9 out of times it will work, but you know how it is tough to convince users, even if the errors comes up just 1 out of 10 times)
I wonder if the solution might be generation of a random number. Is there a way to randomly generate a unique number in infopath?
I am primarily using Infopath 2007 , but I also have Infopath 2010 on another computer (still learning though).