Need Help to Create Relations between 4 Tables in access 2010

[AdamT]

I have four tables.
I would like to define Table-1 as parent. Table-2 as Children, Table-3 as Grandchildren, and Table-4 as a Great Grandchild. I would be grateful to anybody can help me to define these relationship between the tables.

Table-1:

Field Name Data Type Description
ID AutoNumber
ParentID Number Define Parent as First Level (i.e. Level 1)
ChildrenID Number Define Children as Second Level (i.e. Level 2)
GrandchildrenID Number Define Grandchildren as Third Level (i.e. Level 3)
GreatGrandChildrenID Number Define Great Grandchildren as fourth Level (i.e. Level 4)
X1
X2

Table-2:
Field Name Data Type Description
ID AutoNumber
ParentID Number Define Parent as First Level (i.e. Level 1)
ChildrenID Number Define Children as Second Level (i.e. Level 2)
X1
X2

Table-3:
Field Name Data Type Description
ID AutoNumber
ParentID Number Define Parent as First Level (i.e. Level 1)
ChildrenID Number Define Children as Second Level (i.e. Level 2)
GrandchildrenID Number Define Grandchildren as Third Level (i.e. Level 3)
X1
X2

Table-4:
Field Name Data Type Description
ID AutoNumber
ParentID Number Define Parent as First Level (i.e. Level 1)
ChildrenID Number Define Children as Second Level (i.e. Level 2)
GrandchildrenID Number Define Grandchildren as Third Level (i.e. Level 3)


GreatGrandChildrenID Number Define Great Grandchildren as fourth Level (i.e. Level 4)

V/r
Adam

[pbaldy]

Haven't done this type of thing, but I don't think the design is appropriate. I'd lean towards what Allen describes here:

http://allenbrowne.com/ser-06.html

That would be more long-term flexible.

[AdamT]

Paul;

Thank you for your feedback and your time.

V/r
Adam

[pbaldy]

No problem Adam, and welcome to the site. Post back if you get stuck.