Collecting Costs Associated with Tasks of Project

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.