Copying query results into a new record

jdbean86 — Mon, 22 Mar 2010 15:17:56 GMT

Hi! I am a new InfoPath user, and I am encountering a problem getting a form set up.

Here is the rhyme and reason behind the design of my form, first of all:

This form is to be used in the security offices at the plant I work at for the purposes of employee call offs. Once the form is filled out, it will be submitted into a table on the access database we have. Now, I want the logs to be linked by the employee ID number. The problem with this is that when employees call in, they don't always know their ID number, or only know the old identifier. I built a query on the first page of my form to search the employee records by last name, old identifier, and new identifier.

A repeating list then pops up, and there is a button next to every record that can be clicked to isolate the record (which requeries the database using only that employee ID). It's probably not very efficient, but it moves quickly enough for my purposes. Then the form automatically switches over to another view, where some information is automatically carried over from my information table (department, supervisor, etc etc), to fields for my call log table.

Originally, I had my call log fields set to pull default values from the remaining employee information entry on the first form. This worked great until I realized that trying to submit the 2nd call log for an employee would pull up all the information from the first log automatically.

My problem really is this: when I isolate the employee to submit a call log for, I need to create a new call log record that pulls over some information from the employee records as well as includes a few fields the security office fills.

The code I linked to the button is this:

var sapstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/q:Master_Employee_Table/SAP_ID"); var firststr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:Master_Employee_Table/First_name"); var laststr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:Master_Employee_Table/Last_name"); var namestr = XDocument.DOM.selectSingleNode("//my:CombinedName"); namestr.text = firststr + " " + laststr; var deptstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:Job_Table/Cost_Ctr"); var supstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:Job_Table/Name_of_superior__OM_"); var subsapstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:CallLogs/SAP_ID"); subsapstr = sapstr var subnamestr = XDocument.DOM.selectSingleNode("//my:CombinedName"); subnamestr.text = namestr.text var subdeptstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:CallLogs/Cost_Ctr"); subdepstr = deptstr var subsupstr = XDocument.DOM.selectSingleNode("/d:myFields/d:dataFields/d:CallLogs/Name_of_superior__OM_"); subsupstr = supstr

And it doesn't transfer and show the fields over like I would hope. I am working in javascript, and am in completely foreign territory - I just got saddled with this project because I'm "good with computers." My working knowledge of JS is absolutely zero, so any help you could provide would be amazing. These forums have been invaluable the last week getting other infopath forms set-up, but this one has me for a loss. I've looked at some other threads that may be similar to this, but I'm struggling with understanding what is going on.

Thanks!

Code

Copying query results into a new record