Waste of time putting all that on here.

Start by writing the sql script that would perform this task and work from there.

I may be worng but this sounds fairly straightforward

Graeme