SharePoint 2010 front end for SQL Server Database
Posted on 2013-05-25
I am creating a full application platform for all departments in my organization to interact with my database through the use of SharePoint external content types and InfoPath forms.
I am unable to create the correct forms without using features that are outside the realm of browser enabled forms.
I need to have multiple connections to the database to populate dropdown options.
When I create the form I'm able to quick publish the form with the warning that it must to completed in InfoPath Form Filler. (This would be fine because my users all have InfoPath installed with Office.) However I'm unable to have the default New Item and Edit Item buttons on my external content list open the Form Filler. Instead they simply give an error that the form is not browser compatible.
How can I force the list to open the form filler in the same way a form library would?
Or How can I create a form library that can update to my external content type?
Or Is there a simpler way to complete this task with little to no knowledge of any programing language?
Or At the very least can someone tell me that what I'm attempting is impossible and I need to back up and design a full platform myself and then point me toward some articles or books that could help me to build a platform for my users to use to interact with my database that is web accessible and secure?