Assuming we have 2 document types: TagGroup [DisplayName]
and TagGroupItem [DisplayName]
with TagGroupItems being children of TagGroup. That said, assume we have the following data:
Color - Red - Green - Blue
Finish - Aluminum - Plastic
Color and Finish are both TagGroups. What kind of data type would allow for the another item to be associated with 1 or more tag group items? That is, an item could be Color-Red and Finish-Alumimum or just Color-Red. Aside from manually creating a drop down for each tag group and associating it to an item, how can this be more streamlined?