How to link to the same field in same table?
People table
ID, FirstName, LastName
1, Jane, Doe
2, John, Doe
3, Scott, Doe
4, Sue, Doe
Family Tie table
ID, Family Tie
Mother, Father, Wife, Husband, Sister, Brother
Jane = Wife of John, Mother of Scott, Mother of Sue
John = Husband of Jane, Father of Scott, Father of Sue
Scott = Son of Jane, Son of John, Brother of Sue
Sue = Daughter of Jane, Daughter of John, Sister of Scott
I'm stumped.
Any help would be appreciated.
People table
ID, FirstName, LastName
1, Jane, Doe
2, John, Doe
3, Scott, Doe
4, Sue, Doe
Family Tie table
ID, Family Tie
Mother, Father, Wife, Husband, Sister, Brother
Jane = Wife of John, Mother of Scott, Mother of Sue
John = Husband of Jane, Father of Scott, Father of Sue
Scott = Son of Jane, Son of John, Brother of Sue
Sue = Daughter of Jane, Daughter of John, Sister of Scott
I'm stumped.
Any help would be appreciated.