Change select options based on another select

I have 3 table which is as followed:

School Table has following:

  1. schoolName (String type), Mutliple:NO
  2. classes (Class type), Mutliple:YES

Class Table has following:

  1. className(String type), Mutliple:NO
  2. students (Student type), Mutliple:YES

Student table has following:

  1. id (Long type), Mutliple:NO
  2. name (String type), Mutliple:NO

On my form, I have a container, bind with school collection, which has multiple lines of class.
Collection Image

Each line of class has 2 select fields on my form, one listing all the classnames. The other will list the student names based on the class selected on first select field. And each line is identified by $item, because the binding of collection.

How do I code the field for student name listing?

I can bind the first select (listing class name) using $data.classList. But how do I get the selected value from the first select ?

Question

3 Likes

Hi Citsoon.
Did you find the answer to this?

Appreciate if anyone can help! :smiley:

Hi, did you have any breakthrough or did you find any solution to this, I’m having the same problem. Any idea will be welcome

HI unfortunately I am unable to find any solution or workaround for this. I am hoping that the developer can assist on this.

Unfortunately no :frowning:

Hi jeanov92, did you have any breakthrough or did you find any solution to this, I’m having the same problem. Any idea will be welcome

Hi jeanov92, did you have any breakthrough or did you find any solution to this, I’m having the same problem. Any idea will be welcome

Hi jeanov92, did you have any breakthrough or did you find any solution to this, I’m having the same problem. Any idea will be welcome