• Thats excellent advice, many thanks.

    Now I know that I can include the same attribute in multiple subtypes of the same supertype my conceptual ERD is going to look a lot cleaner.

    Also I think the OrganisationType column would work well further down the line, its definitely something I'll think about.

    Got to love that good fun learning curve! 🙂