Parent ID

[digit]

Is there someone why can tell me how can i make a Tree where every person mest have a parent? Please help me

 

[Mile-O]

Create a table with three fields:

tblTree
ID (autonumber)
Node (text)
ParentID (number)

The ParentID references the ID field.

 

[digit]

re

Ok , thanks , but how can i generate a report with that strructure to view as a tree

 

[Mile-O]

A tree in a report; I don't know.


Here's the recursion procedure for the treeview control: Q167309

Does that help?

 

[digit]

what was that Q167309

 

[Mile-O]

Didn't you follow the link?

Or have you confused me with your original minimal question? I guessed that by your mention of "tree" you were wanting to use the treeview control to present data.

...but you've since said report...

...in the queries forum...

...detail your question further.

 

[digit]

many thaks that help