Filter third field based on two fields above

Nov 19, 2010 at 9:22 AM

I have three lists.

  • Manufacturers
  • Series
  • Types

In my fourth list Products I need to add the manufacturer, which has several series available, and types within these series.
Using cascaded lookups, when I filter on manufacturer I get the correct series, and when I filter on series I get the correct types. But the problem is that I get all the types available, not the types from the manufacturer. I need to filter my third column based on the first in combination with the second.
(a certain serie can be used by a number of manufacturers, and a certain type is not used by all manufacturars, even though they offer this serie)
If I explained well, you see that I also have a reference between the ParentList and SubChildList.

Any idea on how to handle this?

Thanks in advance.