Newbie Questions

Re: Autopopulate from Access Database

Hilary Stoupa — Fri, 22 Aug 2008 23:38:16 GMT

You need to double check your xpath -- did you select the @ClientName field using the Insert Field or Group button?

Re: Autopopulate from Access Database

Michael Campbell — Tue, 19 Aug 2008 04:01:01 GMT

Matt

I have used your clients.xml to review the data in a drop down and populate other fields and this works perfectly.

I am now attempting the same, but using an external data source (Acess 2007) table. When I add the XSL conditional statement (as per step 10) I get an error. Is this different when connecting to Access as opposed to XML?

xdXDocument:GetDOM("Clients")/dfs:myFields/dfs:dataFields/d:Clients/@ClientName [../ID = current()]

Error I get is: "xdXDocument:GetDOM("Clients")/dfs:myFields/dfs:dataFields/d:Clients/ID" does not point to a valid location path of a field or group.

Thanks

Michael

Re: Autopopulate from Access Database

robbieswife2b — Wed, 13 Jun 2007 08:39:08 GMT

Thanks for your help, I finally got there (very proud of myself!).

Re: Autopopulate from Access Database

Matt Faus — Mon, 11 Jun 2007 11:57:32 GMT

Hi Future Mrs. Robbie,

This isn't too complicate - hopefully these steps will get you on your way!

Add the connection to the Access database, and make sure that it queries whenever the form loads
Add the drop-down to the view and populate it with the repeating section that was created from Step 1
Follow this blog to pull the data from the repeating section and put it in your form. http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspx

Further reference:

http://www.infopathdev.com/blogs/greg/archive/2004/07/28/Populate-a-Drop_2D00_Down-List-Box-via-a-Secondary-Data-Source.aspx

Autopopulate from Access Database

robbieswife2b — Fri, 08 Jun 2007 09:28:25 GMT

I have a form to get done asap - have been working on it for ages. Basically I want to select a person from a drop down list and then autopopulate another 5 fields with their uniaue data. All of the information is in an Access database - I just need step by step instructions how to link/filter them.

The fields are - Name (drop down of 75 people) and then PC Name, PC Comments, VPN, VPN Comments.

Any help much appreciated.

cheers