Field values in Project

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

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

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

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

Female
42 Posts
970 Points
Joined: 2010-10-28
Last Online:
2011-8-31 2:49
Location: India
Monika replied on 2011-2-9 6:17

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();

 

}

Page 1 of 1 (2 items) | Get this RSS feed | Bookmark and Share