A strataplan is a building
I have 4 tables
1.
Infosheet_T
(Infosheet_T is a record of services provided for the strataplan by contractors)
Field: kf_StrataPlan_ID, one to many relationship with kp_StrataPlan_ID : allows me to relate the infosheet with the strataplan record (this allows me to bring in fields from the StrataPlan_T, like the building name, or the address.
Join: 2: All of strataplan table records, only equal Infosheet (what is the equal field? - kp and kf keys?)
This is a combobox on the Infosheet record. A list of 14 building codes.
Field: kf_Services_ID, one to many relationship with kp_Services_ID : allows me to select the services the building needs, like window washing or garbage collection.
This is a combobox on the infosheet record. A list of 52 services.
Field: kf_Contractor_ID, one to many relationship with kp_Contractor_ID : allow me to selector a contractor and any related field in the contractor table, like an email, or telephone number.
So this requires joining 4 tables.
In the end I have a record that shows date but nothing is selectable. My comboboxes all show the correct list but none are selectable.
What is wrong.
Thinking that I might have 'ambiguous joins' I created joins and then used the to create joins. (the outer and inner concept makes sense but I am not sure when to choose which)
Anyhow I am seriously confused and nowhere on the internet can I find an example of joining 4 tables.
Please help.
PS: I am working on 04_Infosheet in the attached db
I have 4 tables
1.
Infosheet_T
(Infosheet_T is a record of services provided for the strataplan by contractors)
Field: kf_StrataPlan_ID, one to many relationship with kp_StrataPlan_ID : allows me to relate the infosheet with the strataplan record (this allows me to bring in fields from the StrataPlan_T, like the building name, or the address.
Join: 2: All of strataplan table records, only equal Infosheet (what is the equal field? - kp and kf keys?)
This is a combobox on the Infosheet record. A list of 14 building codes.
Field: kf_Services_ID, one to many relationship with kp_Services_ID : allows me to select the services the building needs, like window washing or garbage collection.
This is a combobox on the infosheet record. A list of 52 services.
Field: kf_Contractor_ID, one to many relationship with kp_Contractor_ID : allow me to selector a contractor and any related field in the contractor table, like an email, or telephone number.
So this requires joining 4 tables.
In the end I have a record that shows date but nothing is selectable. My comboboxes all show the correct list but none are selectable.
What is wrong.
Thinking that I might have 'ambiguous joins' I created joins and then used the to create joins. (the outer and inner concept makes sense but I am not sure when to choose which)
Anyhow I am seriously confused and nowhere on the internet can I find an example of joining 4 tables.
Please help.
PS: I am working on 04_Infosheet in the attached db