Re: Noob Question: about Textbox in a repeating table

Lockdown — Tue, 16 Aug 2011 22:33:29 GMT

Ya, it definitely looks like you have to use current(). This is the way I used it though, it may be of some help.

xdXDocument:GetDOM("Specifications")/Specifications/FlatFileSpecs/CCR/Header/RecordID/Description[current()/@PmtMethod = "CCR"]

So yours will looks something like this.

"Query for ITEM_TYPE"[current()/ITEM_ID = ABC] | "Query for ITEM_TYPE"[current()/ITEM_ID = DEF]

Post the function you are using to populated the ITEM_TYPE text box.

Noob Question: about Textbox in a repeating table

spider — Mon, 15 Aug 2011 09:38:03 GMT

Hi All,

I am working with infopath 2003 and access 2003. The acces database contains tables for both recieving data and for sending data.

My problem is that:

1) My infopath form has a 2 textboxes. One (ITEM_ID) is used by the user to type in the data. The other (ITEM_TYPE) is automatically populated from another ACCESS table. Each Item ID has a one-to-one relation with the ITEM_TYPE.

2) Normally, a user adds 3 ITEM_IDs and hence the need to use a repeating table.

3) When I input the first ITEM_ID, the infopath form queries the ACCESS Table and fills in the ITEM_TYPE into the second textbox automatically. so far so good.

4) When I input the second or third ITEM_ID, the form queries the ACCESS TABLE, but still uses the same ITEM_TYPE from the first query into the second textbox.

It Looks like this

------------------------------------------------------------

Item_ID Item_Type

ABC abc

DEF abc

----------------------------------------------------------

It should look like this:

----------------------------------------------------

Item_ID Item_Type

ABC abc

DEF def

-------------------------------------------------------

I have been reading around and know that there is something called a Current() function, but I cannot get it to work. How can I force infopath to throw out all information from the previous ITEM query before it proceeds with the second query.

Regards,

spider

Newbie Questions

Re: Noob Question: about Textbox in a repeating table

Noob Question: about Textbox in a repeating table