matheusandrade
New Member
- Joined
- Jan 12, 2015
- Messages
- 1
Hey all! I want to develop a database containing some base concepts that will assume a top hierarchical position (Hierarchy = 0), originating derived concepts that will group themselves in hierarchical levels as well. I want my tables and query results to display the parent and child concepts along with the queried item, as they may belong to different areas or fields of knowledge.
Each concept has also a unique ID to help identifying and establishing relationships, so it would work like this:
[ID = 1] - [Hierarchy = 0] - [Concept = "bake"] - [Child concepts = "bakery"; "baking"]
[ID = 2] - [Hierarchy = 1] - [Concept = "bakery"] - [Parent concepts = "bake"] - [Children concepts = "cookies", "soda bread"]
The database would have be read-only for end-users, who are not tech-savvy, so using a second table and a query to achieve this would not be a great solution; instead I'd want to have a field for each entry that would be automatically 'triggered' and insert the Parent and Children values as another field in the entry.
Any thoughts? I know it might have an easy solutions but just can't figure it out
Each concept has also a unique ID to help identifying and establishing relationships, so it would work like this:
[ID = 1] - [Hierarchy = 0] - [Concept = "bake"] - [Child concepts = "bakery"; "baking"]
[ID = 2] - [Hierarchy = 1] - [Concept = "bakery"] - [Parent concepts = "bake"] - [Children concepts = "cookies", "soda bread"]
The database would have be read-only for end-users, who are not tech-savvy, so using a second table and a query to achieve this would not be a great solution; instead I'd want to have a field for each entry that would be automatically 'triggered' and insert the Parent and Children values as another field in the entry.
Any thoughts? I know it might have an easy solutions but just can't figure it out
