Food Boxes - m:n connection and output

[TheBavarianBox]

Hi Community,
I have a product database (different foods). We want to package different foods in different boxes (e.g. Snack Box). A product can be in several boxes.
As outcome I would like to see the boxes and its products with an overview about the price of the box, weight, number of articles, etc.
So far I wasn’t able to get this done. I have tried some many to many templates but was not successful yet.
Thanks for your help!

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

You may wish to mention in what way it is many to many relationship.

In general are you able to add products to each box through referencing? Then with reverse referencing you could see related boxes for each of the foods( or products).

You could further elaborate your requirement.

[TheBavarianBox]

Thanks.
One Box has many foods.
One Food can be in may boxes.

[Suvrutt_Gurjar]

Hi ,
Please take a look at the following post

HOW TO DO MANY TO MANY RELATIONSHIP MODELLING... Questions

HOW TO DO MANY TO MANY RELATIONSHIP MODELLING IN APPSHEET?

https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=83b...

AppSheet expert @MultiTech_Visions has also shared a tips and tricks post on the topic

Many-to-Many Relationships Tips & Tricks 💡

AppSheet be default supports One-to-many relationships: you have one record (say an Order) that has many related records (order details). But there is another relationship connection type that allows you to connect many records to many records you have a table of records (say Products) where each record can be related to many records in another table (say orders). this means when you look at a product, you can see a bunch of related orders - and when you look at an order, you will see a bu…