Forum Discussion
Unable to filter a stylecode
I have a data model with a Y2_Sales table containing sales data, another Y2_Style table with all item information, and a final Y2_Style_color table containing item information at color level. Tab...
I've tried putting the filter in both directions between the Y2_Style and Y2_Style_color tables, but it doesn't filter. I've tried linking the Y2_Style_color and Y2_Sales tables via the stylecode directly with a many-to-many relationship in both directions, but it doesn't filter either.
Do you have any other ideas?
Thanks audreygerred
Did you try the suggestion of concatenation of style code and color to create the key?
I don't see how I can do this, as the stylecode in Y2_Style is unique and the data is emptied every night and extracted from another program. Each stylecode has several colors, so I'd have to make 1 line with each color, but the stylecode would no longer be unique...
