Expand|Select|Wrap|Line Numbers
- Projects (table)
- projectID
- title
- other fields
- - Sections (table) relates to a project in Projects
- sectionID
- projectID (used to relate to Projects)
- section title
- other fields
- - Rules (table) relates to a section in Sections
- ruleID
- sectionID (used to relate to Sections)
- some fields
- - notes (table) relates to a specific rule in Rules
- noteID
- ruleID (used to relate to Rules)
- note field
- - ToDo (table) also relates to SAME rule as notes above in Rules
- todoID
- ruleID (used to relate to Rules)
What I want to do is have a form where I can scroll through Projects and display all the sections relating to that project. And scrolling through Sections display all the rules associated with that sections. Notes and ToDo's relating to each rule should then display.
Further info: in Relationships - all the tables are related correctly to each other. My problem is how to build a form so that it
a) displays all the various tables and
b) changing a parent changes the children. E.g. going to the next rule, displays the Notes and ToDo's that relate to that rule.