InfoPath Dev

I got this working finally. Again thanks for all the help that you have been.

so both the QFR_Number and the hyperlink are in the same group. The number is what I am trying to get when the hyperlink is clicked. So if i use the relative path will I be able to get the number that goes with hyperlink that got clicked?

Ok so that would work but the node that I need isn't actually the same one that gets clicked. It is in the same group but it is the ID of the hyperlink. Is there a way to get that name without doing SelectSingleNode because that just gets the first instance.

Alright I will try to get some time to mess around with it a bit today and report back with my findings. Thanks again for all of your help.

What do you use for a situation like this?

Do you have any thoughts on how to cycle through the nodes when I am using the on_ContextChanged?

Yes I am handling this in the on contextchanged event.

Ok so I got it to insert into the database. YEAH!!!!!! Thank you so much for all of your help with this. One more thing if that is alright. The code that I am using only brings back the first instance of QFR_Number field on the form even when i click the second instance in a repeating section. Is there a way to figure out what "node", or ...

Ok so i do have the auto generated ID column set as my PK because the QFR_Number is going to be repeated. From what I read in your post is the only thing that I need to do in my stored proc is to set implicit_transactions off?

So it looks like it is executing the SP but after it gets done it rolls the changes back for some reason. I am not sure why it would be doing this.