to be honest it was trying to solve a problem the long way round
rather than rethinking the design of the main table, I agree with you
was being lazy but in the long run it has to be changed otherwise the
could be further complications.

thanks