Hoping Hilary can help:
I have a SP 2010 list I'm customizing in InfoPath. I have a drop-down field with a data connection to another SP List (the field name I'd like is a lookup column to yet another SP list). The drop-down is giving me the ID instead of name I've chosen. I've reviewed all forums online but ...