I’m kind of a noob and I’m trying to understand the database. Can someone explain to me how the relationships work? As an example I have added an image.
If I want to create a shop in Adalo and filter all products by categories. Example: when entering the shop you first choose a main category (Men, women, children) Then you choose a sub-category (Bags, Shoes, clothing) Then you choose a sub-sub-category (carry bag, handbag, backpack) If you have made the choice, you will enter the list with all products belonging to the chosen category.
I understand that you have to work with lists, but I can’t get the hang of setting up the database in such a way that it communicates with each other.
Then immediately comes the next question.
I also want to make an option in the app for administrators to add products. This works fine, but I get stuck with the option to immediately give the product the right categories. I’m trying with multiple dropdown but how does this option communicate with the database?
Hopefully I’m not asking too much but I’ve been stuck with this problem for 2 days. Hopefully someone has the solution for me and maybe other Adalo users.
Thank you in advance.
Kind regards, Patrick