Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To restrict values in a drop-down in a Company Parameter (CP) key column based on another Company Parameter column:

  1. Open a Company Parameter table and right click the column you want to use as a source.

  2. Click Add Columns to 'Rename.../Restrict Values' List.

...

  1. Image Added
  2. Go to the column you want to restrict and click Rename and Customize Column.

  3. In the Restrict Values drop-down select by Data Source.

...

  1. Image Added
  2. Click the add button Select a Data Source Field and in the popup window select the Data Source you marked as the source column.

  3. Select the field you want from the Fields picker and click the Select icon. 

  4. Refresh the Company Parameter table to see the effect.

This applies only to the matrix tables.