AX 2012: Display methods – Different datasources – Same control

Posted on Updated on

AX developers always come across a requirement of showing data from different datasources on the same control though these datasources should be related to each other. The solution to this requirement is to define display methods on the table which you choose to be the control datasource. Display methods are very handy for showing data from related tables.

Consider for example the following tables:

1. CustTable
2. DirPartyTable
3. BankGroup

If we need to show CustTable.AccountNum, DirPartyTable.Name and BankGroup.Name fields on the same control let’s say a grid control then we need to define the following display methods on CustTable if we have chosen CustTable as the grid’s datasource.

To retrieve DirPartyTable.Name

Untitled

To retrieve BankGroup.Name

Untitled

Now on the grid control, add  two StringEdit controls to bind them with the display methods just defined above. Make sure to specify CustTable as the grid’s datasource. Also you must be setting DataMethod property of the StringEdit controls to the name of the respective display methods.

Untitled

The result is awesome. You have one grid control showing data from different datasources!

Untitled

Advertisements

One thought on “AX 2012: Display methods – Different datasources – Same control

    dlfjdml said:
    November 26, 2015 at 3:17 pm

    Fantastic article, thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s