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
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
Attachments
Last edited: