• thanks for the response.

    The sons will have different information to the fathers .

    and the sons wont be a father.

    I am leaning towards having 2 tables

    a Father table and a Son table as a father can have more than one son..with the links between the two

    thanks

    Fred