4.2.1 How to define Cascading dependencies between columns in RDA module in Form Wizards

Abbreviations, used in the manual:

RDA - Reference Data Admin

FW - Form Wizard

Note: column used in the field “Dynamic Variable” in the FW in Step 2, can’t be of type Multi-select or Dynamic Multi-select List!

 

For example, we have a table named “cascading_dropdowns”.

In this specific example we are using  Oracle DB, columns "ID", NUMBER_COL - are of type number; columns NAME, SURNAME, NUMBER_ALIAS -  are of type varchar2.

We will create  using table “cascading_dropdowns”:

 

The first DD's name will be "cascade_name_value", it will contain values from column NAME in "Value column" field, values from column SURNAME in "Caption column" field, and value "ID" in "Column Variable (Optional)":

 

 

Note: column, chosen in the field "Column Variable (Optional)", must be presented in the select statement in the field "Dropdown query"!

 

The second DD's name will be "cascade_number_value", it will contain values from the column NUMBER_COL in the "Value column" field, values from column NUMBER_ALIAS in the "Caption column" field and value "ID" in the "Column Variable (Optional)":​

 

 

The third DD will contain values from the column ID in the field "Value column"  and in the "Caption column" field and won't contain value in the field "Column Variable (Optional)":

 

 

Now we will build the RDA FW:
We’ll use for this purpose Oracle DB table named “cascading” (column ID - is of type number, column NUMBER_COL - is of type number, column NAME - is of type varchar2):

 

 

FW Step2:

In our example, it means that DD used in the ID column can’t be of type “Multi-select List” or “Dynamic Multi-select List”:

 

 

 

 

 

That's it!
When the RDA Editor will add/edit rows to the FW, the 2 columns will be “connected”
For example: value “4” for ID => Number col = Three, Name = Anikin: