Create a preference that only allows for one change task to be created per change notice.
In my company we do not allow for multiple tasks to be created per a single change notice. The problem is that there is no way to control it. When a user does not follow this, it creates a lot of problem.
Reports for manufacturing do not work correctly.
Need to reseed the table to a later change number for both activity and notice.
Stop all affected change notices/tasks and recreate them.
I know that not all companies follow this, but I would think that there would be alot of them that only use one task per notice and that is why it should be a preference.