InfoPath Dev

Thank you. I was unable to open it earlier and opening it with Design was the key. I am trying to piece together what you did. It is starting to make sense, but there are some pieces I need clarified. The Title_Lookup field on the Secondary data connection, is that something that I need to add? If I were to add it, I would need to know what it ...

Would you be willing to post the formulas you used to calculate the value? I spent the majority of my day yesterday trying anything I could think of, including trying to calculate the value and still only managed to pull in the ID. [quote user="Hilary Stoupa"]Okay, but you see, the thing is the underlying data type is an integer - ...