# How to Keep Formula While Adding New Lines to Database

**URL:** <https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274>\
**Category:** Ask for Help\
**Created:** [April 7, 2021, 8:55pm UTC](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274 "2021-04-07T20:55:23Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [April 19, 2021, 7:35am UTC](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274/21 "2021-04-19T07:35:35Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2021, 9:31am UTC](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274/22 "2021-04-19T09:31:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [April 19, 2021, 10:08am UTC](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274/23 "2021-04-19T10:08:44Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2021, 12:30pm UTC](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274/24 "2021-04-19T12:30:19Z")

</div>

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).

[Previous page](https://community.glideapps.com/t/how-to-keep-formula-while-adding-new-lines-to-database/25274.md?page=1)