Ok my enviroment is as follows -
SharePoint 2010 platform up and running
SQL server platform with custom databases on a seperate machine
I need to use SharePoint as the front-end access to my SQL DB.
I have established serveral external lists that are working well with Infopath 2010 forms for several views that consist of a single table select query.
I have now been asked to handle a project of updating fields in a view that contains fields from multiple base tables. I need to update information that is in a single table however it is linked in the view to an Employee table using an EmployeeID and displaying FirstName LastName etc, about the employee in the list view of the External List. It seems that Infopath errors when sumbitting the data because it is trying to update all the fields of the External List which is on multiple tables. Is there a way to make Infopath only submit the few fields that I am actually updating in this application without erroring itself out trying to submit to the Employee table as well or is there a better way to go about getting the connection to SharePoint configured to handle submitting to multiple tables?
I have done a few days of Googling without much luck. Can anyone point me in a direction that can either solve this problem or help me ask the right questions?