Many to many relationship with EnumList?

HCF
New Member

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?

0 3 188
3 REPLIES 3

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.

Top Labels in this Space