Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Create parent/child relationships between records in the same table (with rollup/sum capabilities)

cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Culley
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

I am trying to create a company budget database where all the accounts are in the main table (grid view), but some of them are subaccounts of other accounts (and others are sub-sub-accounts, etc.). All the parent/child relationships are between records in the same table. How do I display the data where the sub accounts are indented under their parent records and can roll up at each step of the hierarchy, if desired (including a calculated sum field) For example, 

100 Personnel Costs ($250K) <-- This is a calculated roll-up from subaccounts

        110 Salary & Wages ($200K)

        120 Healthcare ($50K)

200 Facilities ($65K)  <-- Calculated

        210 Rent ($30K)

        220 Maintenance ($20K)

        230 Exterior ($15K)  <-- Calculated

                231 Grounds ($10K)

                232 Signage ($5K)

etc....

It would be nice to roll up the budgeted amounts for each subaccount into a field in its parent account.

I tried the List view type, but that requires a relationship between records in two different tables.

 

 

2 Comments
Jeremy_Chevalli
6 - Interface Innovator
6 - Interface Innovator

yes I need this too

julioproano
4 - Data Explorer
4 - Data Explorer

I have a similar scenario where i would like to have "subtasks" created from and original task record in the same base. I found a tentatively solution adding an additional table for "subtasks". I would like to avoid having another table.