Many to Many Relationship within Same Table

[DBlackatDJM]

Problem: I've created a master table of all of the companies we work with. I've created slices to work with different types of companies. (Dealer, Manufacturer, End User, Buying Group).

Goal: How can I create Many to Many relationships between Manufacturers <=> Buying Groups as well as Dealers <=> Buying Groups?

[Markus_Malessa · Accepted solution]

Either a column of type EnumList (subtype REF) column on one of the tables or both. Or creating an additional table for each M-2-M relationship that just stores the key columns of the respective tables.