Skip to main content

Selection Page with Prompt

In a selection page, prompts can be filtered automatically based on other values entered in the same page. For example, in a selection screen with the General Ledger setting and GL Account, the value in the General Ledger parameter can be used to filter the list of GL Accounts so only relevant accounts are displayed.

Create and link prompts in a selection page​

Create a selection page​

  1. Select Data Models and Views from the navigation panel.
  2. Right-click a data model and select Edit Selection Pages.
  3. Click Add.
  4. Enter a name for the selection page.
  5. In the Field list, select the fields you want to include. Selected fields automatically appear in the main panel (e.g., Product Stats 1 and Product Stats 2).
  6. Edit the selection page properties as needed.
  7. Click Confirm.

To ensure the prompt in one field is filtered by the value of another field:

  1. Right-click the same data model and select Data Model Designer.
  2. Add a column (for example, Product Stats 2) whose values depend on another field (such as Product Stats 1). Use a calculated column or reference column as appropriate for your scenario.
  3. Configure the correct global parameter for this column so it links to the controlling field's value.
  4. On the File tab, click Save Data Model.