RDA Designer - Cascading Dropdowns user guide

Introduction

This manual will guide you how to define cascading between Dropdown list (Dynamic). Cascading between lists gives the designer the power to define 2 or more drop downs with condition which affect each list to the other.

For example, let's say we have a table name “cascadingdropdowns” (in this specific case it’s Oracle; ID, NUMBERCOL - number; NAME, SURNAME, NUMBER_ALIAS - VARCHAR2) and we will create Drop downs using this table.

Step 1 - Define the drop downs:

First drop down - will present the user Surname but in the table will be inserted Name. Drop down definition:

Second drop down - will present the user Alias and in the DB table it will be a number value.
Drop down definition:

Third dropdown - will present the user ID and will insert the ID to the DB table. Drop down definition:

Step 2 - Define the form:

We’ll use in this example table name “cascading”:

Form definition:

Step1

Step2 - Define dynamic variable in list

Step2 - define normal list

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