Attachment 3783Hi all
I am stuggling to set up a line of 7 combo boxes that filter down to restrict the user to have only certain options to select.
Box 1 = price set product range (eg. A, B, C )
Box 2 = Suppliers (eg. H, I, J )
Box 3 = Brands (eg. N, M, O)
Box 4 = Style (eg. R, S, T )
Box 5 = Colour
Box 6 = Design
Box 7 = Finish
I select C from box 1 - C is selected - all fine
then I select J from Box 2 because J is the only supplier of this Product Range. - all fine.
when I select Box 3 - I need to see only the brand that my supplier (box 2) stocks and that is within the product range (box 1)
But what happens when I select from Brands (box 3) is all the brands that the supplier (box 2) stocks, it has not filtered from box 1.
(by the way the supplier stocks other 'price set product ranges' also)
Question: Why is Box 3 not filtering this correctly - I believe I have set the string of 'one to many' relationships up correctly - or have I?
See my attached Relationships - do I need to rethink how these are set up?