multiple levels of filtering on a value list

Discussion created by user18951 on Feb 8, 2013
Latest reply on Feb 11, 2013 by 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:



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!