I have a list of schools for which we manage property projects. Each project has the same default set of related tasks. I want to be able to start a new project for a school (chosen from a combo box) and have set of tasks attached to it.
- tblSchool Primary Key= EID
- tblProject Primary Key = ProjectID. Contains also EID to relate to school
- tblTasks Primary Key = TaskID. Contains ProjectID to relate back to project. There are 29 default tasks for any one project.
- Choose which school (EID) from a combo box (I have made a form with a combo box in it called ComboSchool)
- Create the new projectid and insert EID from the combo box into the project EID to relate them
- Copy the tasks attached to the base project (projectid = 1) and relate them to the new project