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”:
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: