Bookshelf Home | Contents | Index | Search | PDF

Siebel Interactive Designer Administration Guide > Advanced Modeling > Creating Trigger and Target Feature Tables >

Trigger and Target Example

---

In this example, you will add Trigger and Target Feature tables that populate a drop-down list with appropriate year values, based on whether a user wants to purchase a new or used car.

At runtime, if the user selects New for Class of Car, they have one option in the Car Year drop-down list.

If the user selects Used, they can choose from a list of year values.

To create the Trigger and Target example:

Create a Target table named YEAR.
Create a Trigger table named CLASS and link it to the target table.
Create UI controls that link to these feature tables.

Each of these steps is explained in the following section.

Creating the YEAR Target Table

Creating the YEAR target table requires three steps:

Creating a target table named YEAR.
Creating row types for the target table.
Populating the target table with values.

Each of these steps is explained in the following procedures.

To create the YEAR target table

In the Pagesets screen, select the Feature Tables tab.
Choose New Record from the applet menu.

A new Feature Table window appears.

Enter a name, without spaces, for the Feature table.
From the Table Type drop-down list, select Target.
Click Save.

To create the row types for the YEAR Target table

In the Feature Tables tab, select the YEAR Target table.
Select the Editor tab.
In the Editor, click New.

A new row appears in the editor.

Click the Row Type picklist icon to open the Feature Table Rowset picklist.
Click New.

The New Rowset dialog appears.

In the Name text box, enter YEAR_NEW.
Click Save.
Repeat this procedure and create a second new rowset named YEAR_USED.

To populate the YEAR target table

In the Feature table editor, create a row with values for the YEAR_NEW rowset.
In the Feature table editor, create a row with values for the YEAR_USED rowset.

Creating the CLASS Trigger Table

Use the following procedure to create the CLASS Trigger Table.

To create the CLASS Trigger Table

In the Pagesets screen, select the Feature Tables tab.
From the Feature Table applet menu, choose New Record.

A new Feature Table window appears.

In the Name text box, enter CLASS.

From the Type drop-down list, select Trigger.

Click Save.
Select the Designer tab.
From the applet menu, choose New Record.
In the Column Name text box, enter YEAR.

In the Designer tab, the Target Table button is enabled.

Click the Target Table button to open the Target Table picklist.
Select the YEAR target table and click OK.
Follow the steps in To enter information in the Feature table.

NOTE:  In the column tied to the Target table, you can only enter row types.

Creating UI Controls to Display the Trigger and Target Values

Use the following procedure to create UI controls to display the Trigger and Target values.

To tie the Trigger and Target Feature tables to UI controls

In the Input UI tab, click New.
Enter values in the new row.
Click Save.
Click New again.
Enter the following values for the second row.
Click Save.

Bookshelf Home | Contents | Index | Search | PDF