I have some tables that has many records and I want to have another table that will be called Macro View and its going to include all the counts of each table.
For example I have one table that is called “Peoples” and it has 50 records there, then I have another table that is called “Animals” and it has 25 records there, then I have another table that is called “Cars” and it has 10 records there.
Now what I want to achieve is that in this MacroView to have the sum of these records like example below:
People : 50
Animals : 25
Cars : 10