Create linked records between three tables

I am doing a project where I have 3 different tables. Workstreams, Deliverables and Tasks.

Each Task is assigned to a Deliverables through a linked record.
Each Deliverables is assigned to a Workstream through a linked record.
Is there a way to automate on the Workstream table a linked record showing all the tasks assigned?

I hope that make sense!

Gabi

In the Workstream table, add a Lookup field referencing the Deliverable's Tasks.

1 Like