Help adding records from one table to another through a Master table
Here is my need. I have created a database for project management with 3 tables. Projects, Active Tasks and Personnel. You would create a new project, and from that record you could add tasks to the project which saves those tasks as records in the "tasks" table. However I have a need to auto import a list of tasks that will be done on every project. In other words, when you create a new project record, it auto imports certain tasks.
My thought was to create a new table called "static tasks." Add the tasks that will display on every "new project." My problem lies here. I need those records, from the static tasks, to be auto imported into the "active tasks" table upon project creation so that they all display through the portal I have created on the "Projects" table layout.
tldr: I need to have records auto imported from a "static tasks" table to the "active tasks" table, associated with the project, upon creation of a new project...