Linking two sheets with related subtables - many to many relationship

Support
1

I have 2 sheets People and Groups. I want the People sheet to list in a sub-table all the Groups People are, in Group sheet to list all the People in those Groups. Is this possible? If not is there a workaround?

2

Hi,

You can refer to this instruction to achieve it:

3

Hello, is this still the current way to implement many-to-many relationships? I have trouble linking the fields in a subtable field.

4

Hi, yes I’m having the same problem right now. I can easily link individual fields, but I can’t link subtable fields at all

5

Hi,

Yes, about Many-to-many relationships, you could still find the information here: Referencing two sheets at once

Regarding Link and Load, please refer to this article: Link & load.

You couldn’t link data from subtables to your form, since a subtable could have many different values entered in an entry, but a regular field would only have one value. Subtable to subtable is the same.

If it’s not what you are looking for, please send a support ticket vis “Need Help”, provide the sheet URL and your demand and grand Ragic Support to access your database so that we could have a closer look.