InfoPath Dev

Hi all, I'm on the next phase of my project... I have my Infopath form working and am now looking to setting up a database to house the saved form data as xml. This might be more of an Access question but I though I would see what suggestions come back. The idea is to save the form data as xml then import each "quote" (as in ...

Works perfectly now :) Thanks a bunch for your help!!

Ah, yes... oops. My bad. I was getting it mixed up where the filter should go and I didn't look at your example properly!

Thanks again Hilary! I think I'm struggling a little getting used to the syntax. I know roughly how it should look but just not quite there. The Course duration is working well, thank you. I tried the CourseGroup filter but came across some syntax type errors - not a valid path to CourseGroup so I ended up using this: ...

Attached is the template with the xml data files. As you can see, there is a repeating table with individual courses and values that populate into other areas. What I want is to simply select a course group to show only courses within that group and for the duration to be updated in the CourseDuration field. Thanks for your help!!

Thanks Hilary :) I just tried using the same formula on a repeating section but it's not working. Is there another approach to a repeating section for this? Thanks again.

Thank you Hilary! That worked :) Yes, a zip file... Brain is too focused on Infopath right now. So, the ../@NAME is referencing the path to the parent node? I just want to get this clear in my head so I can to the other similar forms. Does it matter how the XML is formatted in terms of attributes or elements? I have seen a lot of examples using, ...

Can't seem to attach more than one file at a time!

Hi Hilary, I have attached my contact XML tables and a screen shot of part of my form. As you can see, there is a drop down to select a company. When the company is selected, the contact person and their details needs to be loaded into the relevant fields. I hope this makes sense?

Hi, I have a drop down menu that I want populate some other fields when selected. The data is being drawn from XML tables but it's not working, nothing shows up in the field. I am trying to use the current() function when filtering the data. The Xpath looks like: xdXDocument:GetDOM("Contacts")/CONTACTS/COMPANY/CONTACTPERSON[. = ...