Problems with one grid!

Question

Hi everybody,

I have a problem with one grid, I am working with AX 2012 and I'm modifying the ProdRouteTrans form. In the DataSource, I put the ProdTable, InventDim,ProdBOM and ProdJournalRoute tables. The main table of the ProdRouteTrans form is ProdRouteTrans, but all the other tables doesn't have a relationship with that table. 

Here are the relationships of all the tables I have now in the DataSource:
ProdTable: ProdTable.ProdId == ProdRouteTrans.TransRefId 
ProdTable: ProdTable.InventDimId == InventDim.inventDimId 

ProdBOM: ProdBOM.InventDimId == InventDim.inventDimId
ProdBOM: ProdBOM.ProdId == ProdTable.ProdId

ProdJournalRoute: ProdJournalRoute.ProdId == ProdTable.ProdId
ProdJournalRoute: ProdJournalRoute.ProdInventDimId == InventDim.inventDimId

Now, here are the property fields I modified in the tables of the DataSource
ProdTable
--> JoinSource: ProdRouteTrans 
--> LinkType: InnerJoin 
InventDim
-->JoinSource: ProdBOM
-->LinkType: InnerJoin

ProdBOM
--> JoinSource: ProdTable
--> LinkType: Delayed (default) 

ProdJournalRoute
--> JoinSource: ProdTable 
--> LinkType: InnerJoin 

The grid seems to work fine, but when I order the grid based on a column, the field of my ProdJournalRoute table I put there, stay in the same row! For example, I open the form and the "X" field appears in row 2 it's OK, but when I order the grid based on a column, the "X" fields remains in row 2!

Anyone have idea why?

Greetings!

P.S. It's not CRM, it's dynamics AX 2012

Answer 1

This forum is for Dynamics CRM, so it's unlikely you'll get an answer for Dynamics AX here. I suggest you try posting in the community AX forum

---

Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk