Query Help for Family Tree type

[Nils Titley]

I need help with a query. I am very rusty at this but I am working on
creating a family tree data base.
How records are set up.
ID ParentID Generation Names
1 0 1 Joe Button
2 1 2 Jim Button
3 1 2 Judy Button
4 2 3 Bill Button
5 3 3 Stacy Jones

I want to be able to query this list so that when I am done i have:
Generation Name Clarification for you
1 Joe Button (Parent)
2 Jim Button (Child of Joe but Parent)
3 Bill Button (Child of Judy)
2 Judy Button (Child of Joe but Parent)
3 Stacy Jones (Child of Judy)

How do I write the query?

Thanks for your help

 

[Guest]

I need help with a query. I am very rusty at this but I am working on
creating a family tree data base.
How records are set up.
ID ParentID Generation Names
1 0 1 Joe Button
2 1 2 Jim Button
3 1 2 Judy Button
4 2 3 Bill Button
5 3 3 Stacy Jones

I want to be able to query this list so that when I am done i have:
Generation Name Clarification for you
1 Joe Button (Parent)
2 Jim Button (Child of Joe but Parent)
3 Bill Button (Child of Judy)
2 Judy Button (Child of Joe but Parent)
3 Stacy Jones (Child of Judy)

How do I write the query?

Thanks for your help

 

[Nils Titley]

adam decided not to provide an answer. Can anyone else help?

Thanks

 

[John W. Vinson]

Adam, if you have a question, it's considered polite to post it in the big
textbox, not just a cryptic subject line.