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

    multiple levels of filtering on a value list


      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:





      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:






      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!