Hi, I am currently creating a store app. I first started using the adalo database but recently I switched to airtable. I have two collections, one for products and one for categories. Many products can belong to a category. The problem is that each product does not appears in its corresponding category. In adalo’s database, I was doing it with relationships, but with airtable’s external collection I’m having trouble setting this up.
This is the airtable database
Here are the categories:
But when I enter a category, in this case minutes, I should only see Milanese, but I see all the products:
Thanks