I am trying to use a filter comboBox to filter another comboBox. I have 3 comboBoxes from 3 tables. The first box is a custom list that is linked to filter a second box. The second box then further filters the third box. I have been able to get the first filter to work, but am having difficulties with the second filter.

Any help is appreciated.

Pablo

I thought I would attach an example of what I am doing. One thing I did notice is that the second filtered comboBox is only selecting values from the first series, plus I seem to have lost my relationships in the name fields.

TestScripts.zip

If you by "Combobox" means this ... http://metabuilders.com/Tools/ComboBox.aspx? Could you try to download this:

http://www.fmforums.com/threads/download.php?Number=134828

And ask further if required??

--sd

Soren - Thanks for the response. I saw an earlier post of yours regarding Conditional Value Lists. I downloaded your example and think it may be just what I need. My question is can you do the same thing with three individual tables?

BusinessUnit

Series

SubSeries

Pablo

Yes use Fentons example in the very same thread