Field values in Project

Not Answered This post has 0 verified solutions | 682 Views | 1 Reply | 2 Followers

4 Posts
23 Points
Joined: 2010-3-17
Last Online:
2011-4-12 21:38
Location: Warren USA
Mike posted on 2011-2-8 23:56 rated by 0 users

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!!! Surprise

Your help is greatly appreciated.


All Replies

42 Posts
796 Points
Joined: 2010-10-28
Last Online:
2011-8-31 2:49
Location: India

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



// Add a Range if required.

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







  • | Post Points: 5
Page 1 of 1 (2 items) | Get this RSS feed