Hi again,
I have a table "Tasks". I'd like to be able to make tasks nested. I'd like to have a field that is a lookup on the Tasks form itself. Eg. I'd like the Tasks form to look like this:
Task ParentTask
Wash all dishes
Wash cups Wash all dishes
Wash plates Wash all dishes
Wash bowls Wash all dishes
Rinse cups Wash cups
But as far as I can tell, this doesn't seem to be currently possible? When I try to select the source data for the "ParentTask" lookup field, every table is listed, except for the "Tasks" table. I wondered if there's a possible workaround for this at all?
Many thanks :)
Katie