So I have the following main tables set up:
customers -< programmes -< projects -< sites -< tasks
I've created two import master detail records to import tasks from a template record to an active record for project and site tables and will most likely end up with something like:
programmes: 1 templateprojects: 1 templatesites: x templates (to support standard tasks per service lines, ie. standardised deliveries)
The import master detail works well but I would like to know if it's possible to assign predecessors across a set of project tasks and a set of site tasks. For example;
- imported project tasks could be (p1) start, (p2) deliver, (p3) close- imported site tasks could be (s1) order, (s2) deliver, (s3) install, (s4) test, (s5) complete
During the import of the site tasks to a specific site is it possible always assign a predecessor tasks in the associated project? In the example above, s1 should always have a predecessor of p2 (and if possible p3 should have a predecessor of s5). This way the delivery section of the project is built from the sum of the site tasks.
Any thoughts much appreciated!