InfoPath Dev

 Hello,

I am learning how to create InfoPath forms connected to my Access Web Database which is published to a SharePoint site. When I am looking to create Data Connections, is it better to connect to the Access database stored on a network drive, or to the SharePoint Lists linked to the same database? Our users must be able to see the connected data in the forms, so I would think SharePoint Lists is the best option. However, I am having trouble understanding how to make SharePoint lookup columns in my list display the value I want instead of the ID value coming from the parent list.

For example, I have a form that is meant to pull data from the Projects list to pre-populate the form on Form Load. But the lookup columns in Projects just show ID numbers instead of the display value.

Thanks,

Rob

Hi - you can add another secondary data connection to your Projects list and then use a calculated value or expression box to display the Project title instead of the ID. I found a blog post on this that may help you.

 Thank you. That link was very helpful.