AppSheet many-to-many relationship using MySQL

AppSheet AppSheet Q&A
1

Is there anyone that can help me to set up a many-to-many relationship in AppSheet using MySQL?

I created an intermediate table in my database and also inserted it in AppSheet, but I don’t have any idea on how to continue with that.

I’ll try to explain a little bit more:

I have a table “Quotes” and a table “Suppliers”. Each quote can have one or more suppliers and a supplier can have one or more quotes. For that, I created an intermediate table in my database called quote_supplier.

Screenshot of the intermediate table:

adelinagiurea_0-1648486593567.png
adelinagiurea_0-1648486593567.png871×361 21 KB

I need a form where I can create a new quote and have the possibility to pick one or more suppliers from a dropdown list.

Thanks in advance!

2

The thing is you actually don’t need a intermediate table for that inside AppSheet.

There is a way to select multiple items from another table.

EnumList basetype Ref.

The thing is that AppSheet is capable of this, but you will still need the intermediate table for you to have many-to-many on other softwares that may be feed by your SQL, like BI stuff

1 Like
3

Thank you for your response!

The problem that I have is that I use an EnumList in my quote form where I want to pick multiple suppliers, but when I save the form the data can not be saved in the database.

In MySQL I had a table Quotes and a table Suppliers. The table Quotes has a foreign key of the table Suppliers. But because the quotes can have multiple suppliers, I made an intermediate table.