Link to home
Create AccountLog in
Avatar of CooperRiis
CooperRiis

asked on

SharePoint 2010 front end for SQL Server Database

Mission:

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.

Problem:

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.

Question:

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?
Avatar of CooperRiis
CooperRiis

ASKER

Did I mention that my supervisors are requiring this task to be completed yesterday with little to no knowledge of the work involved in completing the project they have hap-hazardly decided is within my realm of expertise because I simply have the title of IT technician.
ASKER CERTIFIED SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
This product does exactly what I am looking for with little to no coding.