Hey everyone,
I need some architectural advice on how to best implement a multi-level dependent selection on object.
Let me explain using a simple analogy (clothing):
Level 1 (Category): Pants , Dress , Shirt
Level 2 (Material): Leather , Linen , Polyester — These exact same values repeat under every single Level 1 category.
Level 3 (Model): Depends on the combination of both Level 1 and Level 2.
For example: Pants + Leather = Rave Pants , Leather Shorts .
Dress + Leather = Bodycon Leather Dress , Mini Leather Dress .
Level 4 (Issue / Reason): Depends on the specific model (or combination of Category + Material + Model).
Pants + Leather + Rave Pants = Broken Zipper , Cracked Leather , Missing Buckles .
Dress + Linen + Summer Dress = Shrunk After Wash , Torn Seam .
Since standard dependent picklists only look at the immediate parent (Level 3 only knows about "Leather", losing the context of whether "Pants" or "Dress" was selected at Level 1), I'm looking for the cleanest way to build…