InfoPath Dev

It might but I am not sure exactly how to do that.  How would I find out how many characters could fit in a multiline text box.  Also can you give me the steps to do it using data validation.  I am not sure if I am doing it correctly. Thanks  

Hi Daniels- I'm having trouble with the path name to Form2 at the beginning of the code. The form is located in my H:\My Projects\Employee Records project\Start Again\Form2.xsn  I attempted to get the network path name to it by making a button on the form, putting in a rule  to open a form and I found the path to Form2 (see ...

You can limit the amount of characters a user can enter using data validation. Would that meet your requirement?

Is this a browser form? If not, and if you are using InfoPath 2007, I'd like to suggest you try qRules. It is free, and has a CopyData command that will copy repeating data from a secondary data source to the main data source. This will spare you writing code! A link to the download is available here.

Hilary, thanks for the response. The DropDown approach was my first idea too but I was requested to change it to make the available items on the order form more immediately visible. I think what I really need to do is come up with a method of copying the data from the Secondary source to the Main source and perform my calculations from ...

 There are a few problematic things in the code in your first post.  Firstly, this line:  MainSource.SelectSingleNode("/ns10:DirectImportDBForm/ns10:Items", ns);Will return a reference to an XPathNavigator positioned at the ns10:Items node (assuming it exists).  It will not change the position of the MainSource ...

Never mind, I worked out where I had gone wrong. /dfs:myFields/dfs:dataFields/dfs:Stacks[not(@Stack_Name = preceding-sibling::dfs:Stacks/@Stack_Name)] That works.

Thanks Hillary - but I think there has to be an easier way to do this.  All the paths are pasted in after I select the 'Copy XPath'.  I am much more familiar with IP 2003 OM then 2007.  In 2003, all I needed to do was write the following ...

I haven't find the solution yet, Please help. Thanks, Kalyan.

Any field that you want to store data in has to be in the main data source of the form. You probably need to have a repeating group in your main data source with fields for information about the stationary order as well as fields for your calculated values. Then you can use drop down lists that use your SharePoint lists for a data source to allow ...