
I have a form with a string field. In this field I want to display a lookup with the users of my organization (userid and display name). When I select a user I want to save the user’s display name in the form field.
Override the form field’s lookup() method with this code
public void lookup()
{
//super();
Query query;
QueryBuildDataSource qbds;
SysTableLookup lookup;
query = new Query();
qbds = query.addDataSource(tableNum(UserInfo));
lookup = SysTableLookup::newParameters(tableNum(UserInfo), this);
lookup.parmQuery(query);
lookup.addLookupfield(fieldNum(UserInfo, Name),true);//Add it here
lookup.addLookupfield(fieldNum(UserInfo, Id));//Remove True parameter from ID field & add it to Name field
lookup.performFormLookup();
}
Leave a comment