Saving an InfoPath form to SQL
Posted on 2010-01-08
Maybe I'm missing something...I love InfoPath and the power of SQL, but how can I take the contents of a form and dump it into an SQL database when they hit submit on the form? Why would I do this? Because I'm tasked with making a single form for 8 offices that need personal information (PII) from people arriving from other branches. Since this PII, the submitter is permitted to read it, but not all offices need access. So I want to save all the data to a single table in SQL and then read only those fields that are permitted for whichever office needs it. Like health information is only viewable by the medical unit; family and SSN information is only viewable by HR. Thoughts? Lastly, I CANNOT purchase a third party product :( I can use SharePoint if that is an option, but then I cannot limit views when EVERYONE needs to write to a List...anyhow, any help would be great.