Thanks, David - that was indeed what I was suggesting.

Without knowing more about the business it's hard to be more specific. I have implemented Project Tracking solutions in the past (including one for BP) and this tends to be how they need to work, especially if your organisation is using some sort of "Project Methodology" like PRINCE2.

It does complicate the database solution a bit but it's our job to implement software that fits business requirements.