Display user's name when group is selected in select box
Dear Expert,
For my App, there will a setup for companies to assign their own respective groups.
Therefore, I have manually created the groups using JOGET screen. The groups and users are stored in dir_group and dir_user_group.
Now, in company setup, I have a field where user can choose the group.
But, when the group is chosen, I need to show the list of names.
May I know how is this possible?
I tried a simple way by using AJAX. But, seems like AJAX form is always null. In other words, values are not being populated in AJAX Subform.
I have tried both JBCD Binder for Group Select Box:
TRIAL 1 :
select a.groupID,b.name
from dir_user_group a
, dir_group b
where a.groupID like 'frtt%'
and a.groupId = b.id;
TRIAL 2 :
select b.id,b.name
from dir_group b
where b.id like 'frtt%';
