InfoPath Dev

OK - I started from scratch and it seems to be working with ONE major exception.  When I choose my customer and address, the warehouse code dropdown has a number instead of the value.  This has to be because it is a lookup field.  How do I get the name of the field and not its associated ID #?

Thank you very much for your reply.  I watched the video and it was helpful but I have one more question.  Will this work IF the columns in the SharePoint list are "lookup" columns?  I keep getting a number (assuming it is an ID) instead of the value.

Hello everyone.  I am working on my first ever project with SharePoint and InfoPath and I have hit a brick wall.  I was hoping someone would be able to help me out. I have created a series of five SP lists that contain both "lookup" columns and entered text.  I want to create a form using InfoPath that will creating ...