Related Input Select List

Example
Related Select List
Related Input Select Lists

When the option selected in the first Input Select List changes the options available in the second one
Category: Product:
<Division ID="divContainer" Class="font11pt">
  <LineBreak LineCount="2" />
  <Label Caption="Related Input Select Lists" Class="ThemeTextLarger" />
  <LineBreak LineCount="2" />
  <Label Caption="When the option selected in the first Input Select List changes the options available in the second one" ID="lblDesc" Class="ThemeItalic" />
  <LineBreak LineCount="3" />
  <Division ID="divInputs" HtmlDiv="True" IdeDisplayStatus="Collapsed">
    <InputSelectList ID="inpCategory" OptionCaptionColumn="CategoryName" OptionValueColumn="CategoryID" Caption="Category: " DefaultValue="" IncludeBlank="True" IncludeBlankCaption="Select a category" InputRows="1" IdeDisplayStatus="Collapsed">
      <DataLayer Type="XMLFile" ID="dlCategoriesXML" XMLFile="NW_Categories.xml" />
      <EventHandler DhtmlEvent="onChange" IdeDisplayStatus="Collapsed">
        <Action Type="RefreshElement" ElementID="divContainer" ID="actRefresh1" IdeDisplayStatus="Collapsed">
          <LinkParams CategoryName="" />
        </Action>
      </EventHandler>
      <Validation Type="Required" ErrorMsg="You must select a Category!" Class="errorMsg" />
    </InputSelectList>
    <Spaces Size="10" />
    <InputSelectList ID="inpProduct" OptionCaptionColumn="ProductName" OptionValueColumn="ProductName" Caption="Product: " DefaultValue="" InputRows="1" IncludeBlank="True" IncludeBlankCaption="Select a product">
      <DataLayer Type="XMLFile" ID="dlProductsXML" XMLFile="NW_Products.xml" IdeDisplayStatus="Collapsed">
        <ConditionFilter Condition=" = " />
      </DataLayer>
      <Validation Type="Required" ErrorMsg="You must select a Product!" Class="errorMsg" />
    </InputSelectList>
  </Division>
  <LineBreak LineCount="3" />
  <Division ID="divShowButton" Condition="0 = 0" HtmlDiv="True" IdeDisplayStatus="Collapsed">
    <Button ID="btnShowVals" Caption="Show values" IdeDisplayStatus="Collapsed">
      <Action Type="Report" ID="actReport" Validate="True" IdeDisplayStatus="Collapsed">
        <Target Type="Report" Report="RelatedSelectLists">
          <WaitPage />
        </Target>
        <LinkParams Mode="1" />
      </Action>
    </Button>
    <LineBreak LineCount="2" />
  </Division>
  <Division ID="divResults" HtmlDiv="True" Condition="0 = 1" IdeDisplayStatus="Collapsed">
    <Button ID="btnHideVals" Caption="Hide values" IdeDisplayStatus="Collapsed">
      <Action Type="Report" ID="actReport" Validate="True" IdeDisplayStatus="Collapsed">
        <Target Type="Report" Report="RelatedSelectLists" IdeDisplayStatus="Collapsed">
          <WaitPage />
        </Target>
      </Action>
    </Button>
    <LineBreak LineCount="2" />
    <Label Caption="These @Request token values will be available to the next report or task:" ID="lblValues" Class="ThemeItalic" />
    <LineBreak LineCount="2" />
    <Label Caption="@Request .inpCategory~ = &quot;&quot;" IdeDisplayStatus="Collapsed" />
    <LineBreak LineCount="2" />
    <Label Caption="@Request .inpProduct~ = &quot;&quot;" IdeDisplayStatus="Collapsed" />
    <LineBreak LineCount="2" />
  </Division>
  <LineBreak LineCount="23" />
</Division>