I’m trying to accomplish a task manager for a home renovation. The hierarchical layout of tasks is;
Category > Room > Task > Subtask
Each of the above is a table.
- Category: Has 1 or many Rooms.
- Room: Belongs to 1 or many Categories. Has 1 or many tasks.
- Task: Belongs to 1 Room. Has 1 or many subtasks.
- Subtask: Belongs to 1 task
Examples;
Category > Room > Task > Subtask
Plumbing > Kitchen > New pipes > Remove floorboards
> Buy new pipes
> Fit pipes
> Fill with water
Plumbing > Kitchen > Walls > Strip old wallpaper
> Buy wall paint
> paint walls
Electrics > Bathroom > Lights > Remove old light
> Buy light fitting
> Fit new light
I have this working using the Subtask table to enter all the data, with linked fields adding data to the other tables. The Subtask table has linked fields for Task, Room and Category.
My question is this. How do I display what room a task belongs to in the Task table? Or how can I display what Categories a Room belongs to in the Room table? These items are already Linked from the Subtask table so I’m not sure how I accomplish this.
From reading the forum, is the answer Indirect Linking? I saw this post but couldn’t work out if it would solve my issue. How to link linked columns
On the GitHub repo I also saw mention of a Lookup Column but again couldn’t work out if it would solve my issue. https://github.com/seatable/seatable/issues/16#issuecomment-598713645
Thanks.
Images for clarity;