See the attachment
tblMembers contain several fields ,
ID, Gen(Member Generation), EmpName, FID(FatherID = point to the ID of the father in the same file) and Sex.
My question is how to draw a family tree from these fields.
The very first generation is always one person only, and the second generation and over, they could be a one person up to seven persons.
I have up to 10 generations.
So, the second generation, each person could have up to seven sons.
The therd generation, each person could have up to seven sons, and so on for all the next generations, up to tenth generation.