"As late as necessary contraint"
Hello, I have a big project with most tasks being dependent on a "Construction start" milestone. That whole structure is set up and works nicely. Now I have to add some land clearing work as "secondary tasks", they can be executed before the "Construction start"-milestone but they must not delay the main tasks. The land clearing work can only be performed in winter because of bird protection periods, I have set that up with a ressource. The result looks something like this: My problem is I want the land clearing work to be performed as late a necessary, not years in advance at the project start, but without delaying the end date. If I set the task to be scheduled "as late as possible" it moves everything else back and it overloads my resource aswell: Is there a way to fix this without setting manual Dates? The start dates are not yet fixed and I want as few fixed dates as possible so I dont have to manually adapt everything incase there's a change.
Multi-level constraints
I'm tracking workers in the construction industry. The industry is classified into trades - Laborer, Operating Engineer, Carpenter, etc. Each worker can have one or more trades. Within each trade there are specializations or skills. For example, an Operating Engineer could have the skills to use one or more specific machines (digger, bobcat, crane, etc). I need to track each worker's trades and each worker's specialization, if any. Which trade(s) a worker has will determine the pool of specializations/skills he/she can have. How can I create restrictions so that the worker can only have the skills that fall under his/her trade? Below is a simplified sample of my schema: Worker Name John Barbara Trade Name Laborer Operating Engineer WorkerTradeJunction Worker Trade John Laborer Barbara Operating Engineer Skill Skill Trade Pile Driver Laborer Digger Operating Engineer WorkerSkillJunction Worker Skill John Pile Driver Barbara Digger Again: How can I make it so that Barbara (Operating Eng) cannot have the skill of Pile Driver and John (Laborer) cannot have the skill of Digger? Thank you!
