Is it possible to have a many to many relationship build via an EnumList? (Much like what you see in Airtables)
Per now, I have a support table that holds the relationships, but this is producing many extra steps to invoke the relationship.
What I should like, is to select the relations in a form with EnumList of records from another table and to create the relations from these selections so itโs visible from either side. Is it possible or is ther another way?
Did you check Enumlist with base type REF?
I have actually recently tried setting this up myself and was unable to make this work for some reason. I would much rather prefer being able to use EnumList also, because the add/delete rows action in the reference table is a bit clunky in my opinion. In my case the references are actually in a bridge table however so many-to-many rather than one-to-many.
Not sure of course what the OPโs setup is. But I wouldnโt mind getting a better handle on this myself especially as it relates to many-to-many with a EnumList.
@tsuji_koichi - yes, thats working perfect. Now, as mentioned above, I should like to be able to update the many to many relations on both sides based on the selection in the EnumList.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |