I have three tables in MS SQL server 2000 and I am creating an application using VB.Net. I want to read information from two tables and populate the third.
tblProjects - fldProjectNumber, fldCustomerName, fldStartDate
tblTemplate - fldTaskName, fldStartDay, fldOwner
tblTasks - fldProjectNumber, fldTaskName, fldDueDate, fldOwner
In VB.Net I need to read tblProjects and get fldProjectNumber and fldStartDate. I then need to read tblTemplate and get the list of tasks and their start day, and their owner.
These tasks then need to be inserted in to tblTasks where fldDueDate is fldStartDate + fldStartDay (fldStartDay is a number showing how many days before or after the project startdate a task is due).