Tree-structure in one table
I’m pretty new to filemaker, and databases in general, so perhaps my question isn’t making any sense, but here goes anyway:
I have a database over a number of ideas, it’s structured in one table. I would like to implement some kind of tree-structure, where every idea knows it’s father-idea, or from what idea it came. For now i have a field, where the user inserts the name of the father-idea in every idea-record.
Furthermore i need to present all the related ideas, meaning that all ideas who are related in any kind(brother, father, son, grandson, grandfather and so on) will be presented in one search or in one list.
I have worked a bit with some sort of script, trying to loop through the records, but i have a hard time understanding exactly how. I need to store found records and use data from those, to be able to search further on.
I don’t know if it’s the wrong way to do it, or if it’s even possible or if it’s completely gibberish, but please let me know.
Filemaker pro 10
Mac OSX 10.5.8
FM-exp: close to none