Re: Best Practice for Data Source?

Metron4 — Tue, 22 Jan 2013 21:29:12 GMT

Thank you. That link was very helpful.

Re: Best Practice for Data Source?

Hilary Stoupa — Mon, 21 Jan 2013 23:45:28 GMT

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.

Best Practice for Data Source?

Metron4 — Wed, 16 Jan 2013 18:55:54 GMT

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

SharePoint Integration

Re: Best Practice for Data Source?

Re: Best Practice for Data Source?

Best Practice for Data Source?