I know it's abhorrent database design, but I'm experimenting to see if I can achieve unlimited hierarchy for a custom tasks manager in MS Access.
I managed to make this by using a lookup to the same table...
...however after refreshing it returns to looking like this:
All I'm interested in is this tree view, whether it be a table, query, report or form.
I am aware of the multitude of software out there that achieve similar functionality. However the reason I prefer Access is so that I can extend it and customise it completely to my needs.