Relationships' Help needed please (1 Viewer)

[amanco]

Hi,
I attach my DB with the tables, I arranged the tables in the relationship window, and would like to connect them as follows:

tbl_ system (Parent)
-tbl_LookAt1 (child)
--tbl_LookAt2 (grandchild)
---tbl_LookAt3 (grand-grandchild)

Then each of LookAt1-2-3 has:
LookAt1-2-3 (Parent)
-tbl_LookFor1 (child)
--tbl_LookFor2 (grandchild)
---tbl_LookFor3 (grand-grandchild)

[Note that each LookAt table will be connected to all LookFor1-2-3]

Then each of LookFor1-2-3 has:
LookFor1-2-3 (Parent)
-tbl_AKA (child)
-tbl_Definition (Child)
-tbl_Mechanism (child)
-tbl_DescribedBy (child)
...etc...All the Rest as Children, and these children are parents to tbl_Reference (Child)

[Note that each LookFor table will be connected to each of the rest]

[Note that tbl_Reference is connected to each one, where each can have many references]

I am having a problem connecting these to each other, using Normalization. to understand the situation, when examining a patient:

System=Cardiovascular
-LookAt1=Face
--LookAt2=Eyes
---LookAt3=Lens

-LookFor1=Lens Dislocation
--LookFor2= 0
---LookFor3= 0

LookFor1=Lens Dislocation
-A.K.A = 0
-Definition= Upward dislocation of the lens bilateraly.
-Mechanism= Raised Blood Pressure (Reference= Article 234, 2004)
-Described By= Prof. Scott (Reference= Article 1656, 1999)
...etc...

I really appreciate your help please, thanks in advance for taking the time to view my thread