Many to many relations native support

[borja1]

Hi! 

Is it planned that many to many relationships be supported natively by configuring a join table with their references so the configurations do not have to be done with actions? For non-technical people it is very complicated to configure them.

The steps shoould be:

• Create join table
• Reference the 2 Ids with the 2 source tables

And appsheet should allow to use the multiselect to fill it. Currently, when you configure like this, appsheet lets you add to both entities the related join table record one by one. The point is to allow add them as an enumlist.

Thanks and regards.

[WillowMobileSys]

---

@borja1 wrote:

Is it planned that many to many relationships be supported natively by configuring a join table with their references so the configurations do not have to be done with actions? For non-technical people it is very complicated to configure them.

---

Probably not.  Not even proper databases support this natively.  Additionally, it is very use case specific when these type of join tables are needed.

Of course, this doesn't mean that AppSheet cannot create a future feature to do it.  You will want to open a Feature Idea and then be very specific about your idea how to make it work.  Namely, how does one signal to AppSheet that a join table is needed and which two tables should be joined?

[borja1]

Many to many relation with a join table is a common use in every realational db.. I don't see many to many relations as "very use case specific", almost every business case need many to many relations, at least in my experience..

---

@WillowMobileSys wrote:

Namely, how does one signal to AppSheet that a join table is needed and which two tables should be joined?

---

Appsheet does not need to figure which tables, just let the user create the join table. Create the 2 reference fields and reference them to the other tables. Currently, if you do Users, Roles and a join table UsersRoles and reference that table to both Users and Roles, appsheet already let you to add in both Users and Roles the UserRole record. If you could just add it as enumlist or checkbox instead of "table related record".

When you configure this, like any normal db, appsheets already let you add the join records:

Its just that you need to add the rows one by one. 

Regards,