Use the Connectivity tool to link
your Combo Box or List Box object
to query driven layout objects, such as Grid or BarChart.
Before you begin
Before you can link objects, you must populate the OptionList
and the ItemDataList of your Combo Box or List
Box object with data.
About this task
To link your Combo Box or List
Box object to a query driven layout object, perform the
following steps:
Procedure
- In the Palette view, click the Connectivity tool.
- On the visual dashboard, click your Combo Box or List
Box object.
- Click your layout object. The Connection Options wizard
opens.
- In the wizard, specify the source query column that you
want to use to drive your destination object.
To link the objects, you can use the column from the OptionList property,
the column from the ItemDataList property,
or any other column from the result set of the query, that your Combo
Box or List Box object is based
on. If you use the column from the OptionList property,
you link the objects by values that are displayed in your Combo
Box or List Box object. If you
use the column from the ItemDataList property,
you link the objects by hidden values which are different from the
ones that are displayed in your Combo Box or List
Box object. If you use the column from the result set
of the query, that your Combo Box or List
Box object is based on, you link the objects by the values
that are stored in that column.
If you want to link your objects
by values from the OptionList property or the ItemDataList property,
make sure that you specify one and the same column name in the Connection
Options wizard and in the OptionList or
the ItemDataList property of your control object.
Click Next.
- Select the target query column that you want to connect
to your Combo Box or List Box object.
Click Finish.
- In the notification window, click OK.
Results
You linked the objects. The information displayed in your
target layout object now depends on the item selected in your Combo
Box or List Box object.