Food Boxes - m:n connection and output

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!

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.

2 Likes

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

Hi ,
Please take a look at the following post

https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders?appGuidString=83be58ea-1901-4a6d-ac9c-38c7c555d8cd

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

3 Likes