# How to organize this database collection?

**URL:** <https://forum.adalo.com/t/how-to-organize-this-database-collection/11465>\
**Category:** Database\
**Created:** [April 16, 2021, 11:01am UTC](https://forum.adalo.com/t/how-to-organize-this-database-collection/11465 "2021-04-16T11:01:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![marina\_f\_s](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@marina\_f\_s](https://forum.adalo.com/u/marina_f_s)\
**Post date:** [April 16, 2021, 11:01am UTC](https://forum.adalo.com/t/how-to-organize-this-database-collection/11465/1 "2021-04-16T11:01:20Z")

</div>

Hi all, I’m not sure I’m understanding how to move forward. I’m trying to create a food app. I want my database to look something like this:

ALL FOODS:

- Apple
- Banana
- Tomatoes
- Corn
- Chicken
- Beef

I want all foods to go into categories and add a picture for all:

- Fruit: Apple, Banana
- Vegetables: Tomatoes, Corn
- Meat: Chicken, Beef

I also want the same items from the first list to go into another category:

- Salad: Tomatoes, Corn
- Soup: Tomatoes, Chicken

Is this possible? If it is, can someone explain to me where to put things where and how to link them, please?

 ![Screen Shot 2021-04-16 at 12.56.58 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/5e7bf53c5fc09845ee58893b7223d62eb6f287cc.png)

---

<div class="post-metadata">

**Author:** ![KBass](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/kbass/32/7590_2.png) [@KBass](https://forum.adalo.com/u/KBass)\
**Post date:** [April 19, 2021, 3:41am UTC](https://forum.adalo.com/t/how-to-organize-this-database-collection/11465/2 "2021-04-19T03:41:15Z")

</div>

Hi @marina_f_s,

This depends slightly on how you are using it in your app, but here’s how I would initially guide you.

Create a new collection for All Food, Fruit, Vegetables, and Meat. All Food contains Name field only. Fruit, Vegetables, and Meat collections contain Name and Image.

Then, create a collection called Meals which contain Name and a relationship field with All Foods. Use the last option for relationship.

 ![Screen Shot 2021-04-18 at 10.36.58 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/2/2db3166cdf53e0b6b8d3213e2224355c46d34ace.png)  
This allows you to select multiple ingredients for each meal.

 ![Screen Shot 2021-04-18 at 10.38.39 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/33d6a97e9c301ddc7e5a77f3fa77b1739fcbe538.png)  
 ![Screen Shot 2021-04-18 at 10.38.49 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/c/c901678708fd624a19434f33a766075e52f9983b.png)

However, this may not be the best way to do this if you just want a list of ingredients instead of a selection option. Instead of a relationship field, it may be better to create another category named Ingredients and list the ingredients as a description to the meal.

Hope some of this was helpful 🙂