InfoPath Dev

What I have so far: One Dropdownbox getting the different Departments - bound to (@orgunitno(ActiveEmployees)) - based on seconday connection /dfs:myFields/dfs:dataFields/d:ORGANISATIONUNIT - both display name and value are set to @orgunitDescr One Dropdownbox getting the employees - bound to @employeeID (main data source) - based on ...

Hello, Since you experts solved my first question (thanks nukkumatti), I go for another one. I have a secondary source (SQL table) containing EmployeeID, EmployeeInfo and Department. I'd like to populate 1 dropdownbox with the departments en than drill down to the employees in that department. 1) How do I populate the second dropdown with all ...

I Good Nights Rest did the job for me, I've modified the rule to: xdXDocument:GetDOM(''LOCALSALES_ARTICLES'')/dfs:myFields/dfs:dataFields/d:LOCALSALES_ARTICLES/@UnitPrice[../@ArticleID = current()] Now the texbox gets populated. Thanks a million, Jerome. Without your help I never would have found the solution.

Since this is the newbie section: Can you please tell me how i can find the value of ''/my:yourDLL''? I haven't got a clue!

No, It's a SQL datasource. In the meanwhile, i experimented with the 'HOW TO' of Greg Collins http://www.infopathdev.com/howto/tutorials/default.aspx?i=9111ef580f95479890fc18fb2c5bac85) But once again, I cannot alter it so it works against a SQL table iso a XML datafile. Thanks again for your time!

IMHO the best way to tackle this, is to create the ID in your SQL DB as a bigint. For the ID you set Identity to yes Identity seed to 1 Identity increment to 1 From now one you get 1 unique number each time you save. HTH

xdXDocument:GetDOM(''LOCALSALES_ARTICLES'')/dfs:myFields/dfs:dataFields/d:LOCALSALES_ARTICLES/@Unitprice[@ArticleID = current()]/@UnitPrice Gives no result in expression box. I don't know if this is of any importance but the localsales_articles is a secondary data source to pick the correct article to order.

Thanks for your time. I've changed the Xpath formula to xdXDocument:GetDOM(''LOCALSALES_ARTICLES'')/dfs:myFields/dfs:dataFields/d:LOCALSALES_ARTICLES/@UnitPrice[@ArticleID = current()] But still the expressionbox isn't filled in.

I' am trying to full in the article price based on a selected article name. I've added an expressionbox with the formula: xdXDocument:GetDOM(''LOCALSALES_ARTICLES'')/dfs:myFields/dfs:dataFields/d:LOCALSALES_ARTICLES/@UnitPrice[@ArticleID = 4] I came up to that solution by reading http://blogs.msdn.com/infopath/archive/2004/09/13/228881.aspx ...