Database structure question

Hello im building a peer to peer marketplace. Im having a issue with building the database. there needs to be a multi level category system for filtering system

Parent category

Root Category

sub category


(parent category)
Musical Instruments

(root category)

(sub category)
electric guitar

if anyone can assist please let know

Hi @gearmobile,

Welcome to the community :partying_face:

You need three collections for this.

One collection for parent category like Sections.

Another one for root category like categories.

Another one for sub category like instruments.

And then you can have a list of sections and add a link action to the list to another screen to show categories and you can link that one to another screen to show the instruments or if you need to display all in a one list you would need a custom list and another two custom lists inside that list.

And for filtering how you want it to be?

Let us know how it goes!

Thank you

First thank you for your reply ive gotten the data collections added.

how do I go about creating a custom list. is there another tutorial/documentation that covers this I left a screen shot of design for reference