InfoPath Dev

I had a similar problem where the form had to be emailed to an authorising officer, who needed to open it in a specific view. I made a work around it by creating a rule to open the form in the specified view if the field containing the authorising officers ID was not blank. I know its not the best solution but it seems to work for me. Cheers

Hi! I'm workin' on an Infopath application connected to an SQL Server Database in which I've got three tables: Users, applications and type of permissions for each application. The fact is that I want to chose some columns from each of those three tables (user_Id, permissions and application_Id) and store them into a single one (called Main ...

Thanks for this

OH I got it! It ended up looking more like this in the end. xdXDocument:GetDOM(''GetCategories'')/dfs:myFields/dfs:dataFields/ns2:GetCategoriesResponse/ns2:GetCategoriesResult/NewDataSet/Table/SAPCodes/AccountName[../AccountCode = current()] Thanks for you help. That was the little piece that was missing. Now I can go home for the day since ...

Thank you, sometimes the simplest solutions are the hardest for those close to the situation to see.

Thanks Matt, I think I am getting closer. Here is what I have now and the error message I am getting. <?xml version=''1.0'' encoding=''utf-8'' ?> - <NewDataSet> - <Table> - <SAPCodes> <AccountCode>_SYS00000000679</AccountCode> <AccountName>Airfare</AccountName> ...

Thanks. Got it. I am storing in a text field and displaying it in a hyperlink field.

Chris, You will need to use the current() function. The problem is that you are calling getDOM() and it is returning only the top row of that repeating section, your XPath will look something like this, but if this doesn't work, try playing around with other relative paths such as current()/../../ etc. Textbox 1 - ...

I will keep seeing if i can find an answer on the web. I'm just doing analysis and building a small application to see how powerful this tool is so we could recommend it to potential clients, if we see fit. So far I'm just not having much luck with tasks that I feel should be easy to accommplish. Thank you for your help thus far.

Did you try the 'Relink Forms' function on the new SharePoint site? This seems like it would fix the problem. To do this simply click the 'Relink Forms' button in the top left corner of the SharePoint library and check all of the checkboxes and hit OK.