make new field on table and drag on form design
Write code on table methods:
//Created by Loveleen on 29/3/2012
public static void lookupNumberSequenceGroup(FormControl _formControl)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(NumberSequenceGroup), _formControl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
queryBuildDataSource = query.addDataSource(tablenum(NumberSequenceGroup));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(NumberSequenceGroup, Active));
queryBuildRange.value(queryValue(NoYes::Yes));
sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, numberSequenceGroupId));
sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, description));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
//
Call on form datasource field (related)where you want lookup
//Created by Loveleen on 29/3/2012
public void lookup(FormControl _formControl, str _filterStr)
{
super(_formControl, _filterStr);
NumberSequenceGroup::lookupNumberSequenceGroup(_formControl);
}
Write code on table methods:
//Created by Loveleen on 29/3/2012
public static void lookupNumberSequenceGroup(FormControl _formControl)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(NumberSequenceGroup), _formControl);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
queryBuildDataSource = query.addDataSource(tablenum(NumberSequenceGroup));
queryBuildRange = queryBuildDataSource.addRange(fieldnum(NumberSequenceGroup, Active));
queryBuildRange.value(queryValue(NoYes::Yes));
sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, numberSequenceGroupId));
sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, description));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
//
Call on form datasource field (related)where you want lookup
//Created by Loveleen on 29/3/2012
public void lookup(FormControl _formControl, str _filterStr)
{
super(_formControl, _filterStr);
NumberSequenceGroup::lookupNumberSequenceGroup(_formControl);
}
No comments:
Post a Comment