Paul many thanks for the advice.

How ever what would happen further down the line when it comes to implementing the design and if I decide not to roll up the subtypes to the supertype. That would leave me with 4 tables (organisation, charity, company and trust) and the same column "registered address" defined in two separate tables.

Any other thoughts would be very much appreciated as I'm sure i am just missing some basic.