I don't think this is possible in Sage 100c but I thought I'd ask.
We want to store attributes on each item. For example, various attributes could be product type, material, color, etc. For each attribute we'd want to pick its value.
Example:
Attribute = Product Type
- Available choices = apple, pear, banana, cucumber, lettuce, carrot
Attribute = Color
- Available choices = red, yellow, green, orange
So in the item, we'd choose "product type" as the attribute we want to capture for this item and the next drop-down or look up list would only show us values related to the value chosen. So if someone picked "product type" as the attribute, the next drop down would show only the options for the product type, not the color attribute choices. However we could have dozens of attributes we want to capture, so it seems like a "one to many" type relationship is needed.
Is this possible in Sage?