Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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...

Recursive lookup

...however after refreshing it returns to looking like this:

recursion view lost

All I'm interested in is this tree view, whether it be a table, query, report or form.

Any suggestions?

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.

share|improve this question
'vote to close' taggers, please state the criticism – Jay Feb 18 '12 at 23:53
up vote 1 down vote accepted

Generally users should be modifying data in Forms not in a table-view. You can certainly build a relationship for a table to point at itself. But having the tables actually provide the view you want is almost certainly not going to work.

share|improve this answer
Good to know I point at self relationship is okay! The user will just be me, but you're right: table-view was never really designed to be the front end! But what in a form can show objects in a tree? – Jay Feb 12 '12 at 9:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .