I create a new table: zgrpagt with three columns: cr SREL to cr; grp SREL to grp; agt SREL to cnt; I also create two form: list_zgrpagt.htmpl and detail_zgrpagt.
////////////////////////////////////////////////////////////////////////
// Factory: zgrpagt
////////////////////////////////////////////////////////////////////////
OBJECT zgrpagt {
ATTRIBUTES zgrpagt {
agt SREL agt // SRel_Attr_Entry zgrpagt.agt
REQUIRED;
cr SREL cr // SRel_Attr_Entry zgrpagt.cr
REQUIRED;
grp SREL grp // SRel_Attr_Entry zgrpagt.grp
REQUIRED;
last_mod_dt DATE { ON_CI SET NOW; };
last_mod_by SREL cnt { ON_CI SET USER;
ON_NEW DEFAULT USER; };
};
FACTORY zgrpagt {
STANDARD_LISTS {
MLIST OFF;
RLIST OFF;
};
FUNCTION_GROUP "contact";
REL_ATTR id;
};
};
In the form detail_zgrpagt, when creating new record for this form, I put two dtlLookup to display: Group (grp) and Agent (agt). My requirements is when I press search on Agent Field, it only show the member of Group (grp).
I tried
<PDM_MACRO name=dtlLookup hdr="Group" attr="grp" evt="onBlur=\\\"detailSyncEditForms(this)\\\"" make_required="yes">
<PDM_MACRO name=dtlLookup hdr="Agent" attr="agt" evt="onBlur=\\\"detailSyncEditForms(this)\\\"" extraURL="ADDITIONAL_WHERE=group_list.group IN (U'$args.grp')" make_required="yes">
but the Agent search form (list_cnt) show as images attachment. I think I put wrongly parameter in ADDITIONAL_WHERE or I need to do this customization via Javascript?
Kindly please help