quote:

---

Originally posted by xhostx

Is is NOT clear what you want to achieve!!
Are you on the stage of Modeling your Logical design? or designing Entity relation diagram. Tells us more about the scenario if you need help.


thanks alot for your reply.
if it possible for you, Please tel me your idea about Modeling my Logical design and designing ERD.
thank you very much.
--------------------------
Joins are what RDBMS's do for a living

---

quote:

---

Originally posted by xhostx

well, it will be hard for me to provide you with a good example because you never provided any scenario (example).Anyways, it sounds to me like you have Parent <> Child on the Tree model you provided.

This link
http://www.pure-performance.com/2009/03/managing-hierarchical-data-in-sql/
may give you an idea of how you can reference a Child attribute to its parent attribute.
Keep in mind the heritage concept while modeling you data (maybe specific to your case)



--------------------------
Joins are what RDBMS's do for a living

---