4 Replies Latest reply on Jun 8, 2011 10:06 AM by philmodjunk

    Filter value list by value List

    PeterDowns

      Title

      Filter value list by value List

      Post

      Hi

      Have a portal that people can enter projects. In the layout of the portal I have 2 drop down boxes attached to 2 value lists.

      What happens is the first ddbox picks an account, the 2nd ddbox picks a subset of those accounts. It works fine but shows all the subsets of all accounts. But I would like the 2nd ddbox to only pick the related account subset as chosen by the first ddbox.

      The 1st ddbox comes from a table called Funding, the 2nd ddbox comes from a table called ChartofAccounts. They are related by a field called costCentreCode. The relationship is working well as I have another layout where the chartofAccounts is a portal on the funding layout and I can add, edit and delete accounts and subsets. So that is cool.

      So I need to filter the 2nd dropdownbox someway. This is the process I am confused on, my data is right to go it's the steps of the process I have a problem with.

      Thanks in advance

      Cheers

      Peter