How to Keep Formula While Adding New Lines to Database

Ok i think im now familiar with the parent child relation setup
However, does this allow me to view what would be “great grand children” of my projects without going through the “parents” list first?

Can you describe more about the hierarchy here? Do you expect to see a full list of great grand children on the first level or something like that?

Yes. I want to see all great-grandchildren without seeing the grandchildren and their parents. in other words, using the example from the deep dives you sent me if I open a category say Vegetables I want to see all the quantities of e.g

  1. Garlic 8
  2. Onion 7
  3. Leek 15
  4. Spinach 24
    Per project. The inline list view would be nice as it subcategories into Parents e.g

Bulb
Garlic 8
Onion 7
Leek 15

Flowers & leaves
Spinach 24

Basically, that’s it, if this was a recipes app, the main aim is to calculate quantities of ingredients per meal.

I hope it makes sense.

You can do a relation - lookup on the great-grandchildren data to lookup the ID of their parents, then use an inline list and filter by that lookup ID (lookup ID is screen’s parent ID).