InfoPath Dev

I have a drop-down list bound to secondary data source and displaying value, but stores ID. How would I store the actual value in an Expression box? Is it possible to achieve this?  I used the following formula in expression box but doesn't seem to work:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status/@status_text[@pk_review_status = @fk_review_status]

 Note: status_text and pk_review_status are from secondary data source

fk_review_status is in the Main connection (drop down field)

 Please let me know if above formula is incorrect.

Thanks

Stara

Looks like it should be this:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status[@pk_review_status = @fk_review_status]/@status_text

I tried the above. But I get following error message:

 "xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status/@fk_review_status" does not point to a valid location path of a field or group.

Thanks

Where is @fk_review_status located in your main data source? Can you right click on it and select "Copy XPath"? (IP 2007 & 2010)

Where are you placing your expression box on your form? Inside a section? A repeating section or table?

Yes @fk_review_status  is in Main data source. I'm using 2003 (Copy xPath is not available). Yes expression box is in the same form in a repeating table.

Thanks

Is @fk_review_status in the same repeating table that you are putting the expression box in?

If so, this may work:

xdXDocument:GetDOM("Review Status")/dfs:myFields/dfs:dataFields/d:tbl_review_status[@pk_review_status = current()/@fk_review_status]/@status_text

But it is hard to know without seeing your form. You can attach a copy of your template to the Options tab if you'd like someone to take a look.

It worked. Thanks so much.

So what does Current() mean - Does it get current value of fk_status?

Thanks a lot, 

current() is the node that you are currently located at - so, since your expression box is inside a repeating table (bound to a repeating node) - it is the current instance of the node. Here's a link to a blog post that explains it a bit better.