3 Replies Latest reply on Feb 11, 2013 5:46 PM by user18951

    multiple levels of filtering on a value list

    user18951

      I've been scanning the forums, and can't really find anything that I can comprehend that can answer my question.

       

       

      To make a very long story short, I have a products table, consisting of Series, Type, Size, Parts, all related to other tables.

       

       

      See super-simplified version, below:

       

      http://sbfnet.com/graphics/relationships.png

       

       

      I'm trying to have a series of pop-ups that reduce the items available in the subsequent pop-up, 4 layers deep, that simplify product selection for the individuals using the layout. I'm trying to continually reduce whats available in the final PRODUCTID pop up. See super-simplified version, below:

       

       

      http://sbfnet.com/graphics/layout.png

       

       

      I've tried filtering valuelists, using globals in the pop ups and relationships to those global tables, but I can't get this to work that way I need it to. I can get the SERIES to filter the TYPE, but the SERIES doesn't affect the SIZE or PARTS. Basically, I can't figure out how to get an accumulative effect.

       

       

      If anyone has anywhere to look, or any samples, that would be great.

       

       

      Thank you and have a great weekend!

       

       

      Dave