Having a table pull data from another table

[pdevito3]

Hi guys,

So I've looked around online a bit and havent had any luck with this. I have a master table with Projects and SubProjects. Example:

_______Table1________
Project SubProject
Project 1 SubProject 1
Project 1 SubProject 2
Project 2 SubProject 3

I want to make other tables that pull from the original table for their first two columns, but each have other additional columns that are unique to each table. For example:

__________________Table 2___________________
_Project___SubProject___Total Funds___Spent Funds
Project 1 SubProject 1_______$0__________$0
Project 1 SubProject 2_______$0__________$0
Project 2 SubProject 3_______$0__________$0


________________________________Table 3___________________________________
____________________ ____________Jan-14_________ ___________Feb-14_________
_Project___ SubProject___ Estimated Cost___Actual Cost___ Estimated Cost___Actual Cost
Project 1__SubProject 1________$0____________$0___________$0___________$0
Project 1__SubProject 2________$0____________$0___________$0___________$0
Project 2__SubProject 3________$0____________$0___________$0___________$0

My main reasoning for this is for consistancy. I want to be able to add a new project or subproject to the master and have it automatically added accross all of the tables. I'm not making them all one table because I need different tables to be displayed on multiple tabs (like different reports being queried from a data set if this were in Access).

Thanks in advance!