Self join?

[jgnasser]

I am trying to create a family database and all I can figure out is one table with details of each member. The difficulty I have is how to create relationship eg two persons (records) would be related like x IS CHILD OF y, a IS WIFE OF b etc. I would like to be able to do queries like to extract all children of a particular member. Any ideas appreciated.

 

[Mile-O]

I've never thought about genealogical relationships. This is just a suggestion.

I'd advise a search though as I remember somebody (most likely Pat Hartman or The Doc Man) discussing this before.