Linking 3 ComboBoxes

[preeves]

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

[preeves]

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

[Søren Dyhr]

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

[preeves]

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

[Søren Dyhr]

Yes use Fentons example in the very same thread