Field values in Project

Hi, new to Dynamics AX and had a question. The projects form, on the general tab, shows a responcibility section. In that, you can identify who the sales or project manager is. My question is this: Our system shows a number for that value and not a name. Is there a way to show the name instead? I am an end user. If that cant be done, how can I add a column in the grid view to show the name too? I am learning a lot about the system, but need this to be corrected badly, as the users might revolt on me!!! [:O]

Your help is greatly appreciated.

Hi Mike,

You can override the “Look up” method for these fields in the ProjTable Form Data source.

For Example :

public void lookup(FormControl _formControl, str _filterStr)

{

SysTableLookup sysTableLookup;

Query query = new Query();

QueryBuildDataSource qdb;

QueryBuildRange queryBuildRange;

;

qdb = query.addDataSource(tablenum(Tablename));

sysTableLookup = SysTableLookup::newParameters(tablenum(Tablename), _formControl);

// Keep on adding whatever fields you want to come in the grid

sysTableLookup.addLookupfield(fieldnum(Tablename,Fieldname1));

sysTableLookup.addLookupfield(fieldnum(Tablename,Fieldname2));

// Add a Range if required.

queryBuildRange = qdb.addRange(fieldnum(Tablename, Field));

queryBuildRange.value(queryvalue(Value));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}