Setting dependency properties for project tasks in...

[Randy_Flinn]

I am new to Airtable but have spent time using Access, etc. I am creating a Project Tracker that identified Tasks per Project. I then want to capture the costs associated with some of the Tasks. Example…

Project: Renovate Entryway
Task(s):

1. Remove Existing Flooring
2. Install New LVP Flooring
   Underlayment 500 Square Feet $0.45/Square Foot $225.00
   Luxury Vinyl Plank ABC 500 Square Feet $1.65/Square Foot $825.00
3. Paint Area

I have created the Project Tracker Base, Project Table, Task Table and Materials Table. I can expand the the Project to see the Tasks. I can also expand the Task to see the Materials. How do I setup the views to see the information as I have illustrated above?

Thanks