Windows Forms updating Views?
Posted on 2011-10-25
I am a complete novice to Visual Studio 2010/SQL Server 2008, after migrating from Microsoft Access.
Currently we are using SQL server as the backend, with 2 different Access frontends, one for the Manager, the other for the Engineers.
We have a form Called frmJobReports, which has a subform called frmJobReportsSub
The frmJobReports is the detail of the Job, the subform frmJobReportsSub is basically the worksheet for that Job, which could be assigned to multiple engineers.
The Manager inputs the job detail onto the main form and then assigns the Jobs to the engineers using the subform.
The engineers received “their” Jobs based on a View created in SQL which uses the tblJobReports and tblJobReportsSub (the sub is used to filter the records to the logged-in engineer (from terminal services login)).
We want to allow the engineers to update the main form, which is possible in Access, but in Visual studio Windows Forms, this does not seem possible? I gather Views cannot be updated.
Is there a way around this? Many thanks in anticipation.