Get InfoPath to display lookup column value, not ID

If you have ever used a SharePoint list containing lookup columns as a data source in your InfoPath forms, you may have been disappointed to see the value of the lookup is not displayed. Instead of the value, the list ID of the item containing the value is displayed. My ‘Construction Line Items’ list contains three lookup columns: Project, Category, and Product. When I connect to this list fro... »