Populate data in text area from different table based on drop down list
Hi Experts,
This is just an example of what I need to achieve. I have 2 Forms:
- Form "ONE" - with eg. 4 fields one_continent, one_country, one_city, one_comment.
Form "TWO" where based on select box two_city I would like to dynamically populate text fields two_continent, two_country, two_comment from respective fields and with data from table ONE.
1. I don't want to use Ajax sub-form as this is different to what I need to achieve (but logic is the same).
2. I have managed to achieve the same result using select box and grouping (as shown below), but how to make it with text field?
What about performance with select box - I will have a list with ~ 12k records in form ONE of which about 500 will be visible at once in form TWO.
3. Can Bean Shell or form hash variable can be used to make it?
Can you please support me in this one please, attached app example.
APP_TEST_COPY-1-20160402165312.jwa
