Data Connections

Re: Cascade form

bertrand82 — Thu, 15 Nov 2012 13:25:08 GMT

Solved by: http://www.youtube.com/watch?v=0TMSAchM8m0

Re: Cascade form

bertrand82 — Thu, 15 Nov 2012 13:12:59 GMT

Hi, I have created a sharepoint list now.

Can create my sharepointlist in the same structure as the excelfile?

Re: Cascade form

ErnestoM — Thu, 15 Nov 2012 13:02:02 GMT

Hi-

I think the first step is to decide where the will reside. InfoPath won't be able to read data from and update data in an Excel file. This data could live in SQL, or in SharePoint.

Once you have the data available somewhere, then you can create an InfoPath form to update the data. InfoPath will allow you to create a form based on a SharePoint list or based on a SQL table, which then allows the user to update that data.

Hope this helps!

Cascade form

bertrand82 — Thu, 15 Nov 2012 12:39:27 GMT

Hi,

I have excel file with employee information.

Employee nr; Region; Location; Department

I would like my employees to be able to update their information through an infopath form.

When selecting region, only locations in that region will appear, when selecting location within region, olny departments in that location will appear.

Excel file is attached.

Thanks for all help!

VBR Bertrand