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 nothing has worked for me.
List I'm Customizing: Feedback Form. Drop-down field in Feedback Form is "Course Name" that pulls from a Calendar List. That Calendar List has a Course Name field that is a Lookup field on a Course List.
Seems like it should be simple but sure hasn't worked out - any suggestions?