I have two tables in a SQL Server 2000 database; Worksites and Monitors.
I want to 'assign' a Monitor to one or more Worksites.
With table Worksites having columns keyWorksiteID, keyMonitorID and txtWorksiteName. (keyWorksiteID being the Primary or Identity Key)
And table Monitors having columns keyMonitorID, LastName and FirstName. (keyMonitorID is PK)
Using either a GridView in an ASP.Net 2.0 web form or a DataGridView in a windows form, how could I allow a user to select a Worksite from the list of worksites then select a Monitor from the list of monitors and assign that monitor to the selected worksite, then assign the same monitor to additional worksites until some criteria is satisfied?
In basic terms: Pick Worksite from gridview; pick Monitor from another girdview; put keyMonitorID from Monitor table into keyMonitorID of Worksite table; repeat.
Thank you for helping a beginner.
P.S. I'm going to be doing some things like counting the number of Applicants from a third table who are already assigned to each Worksite table so that each Monitor is only assigned to the number of Worksites with a total of, say, 30 Applicants. So, would it be better to make this application a web app or a Windows app?
Thanks.
Start Free Trial
