I have for the fist time created two relations of the type “Related field fixed” between two tables A and B in AX 4.0.
1 = tableA.Closed & tableB.RefRecID= tableA.RefRecID
0 = tableA.Closed & tableB.RefRecID= tableA.RefRecID & tableB.CustRecID = tableA.CustRecID
I’d like to know if it’s possible to create a form with two grids where I can show the link parent-child: I’d like to have a grid with the tableA’s data and another with the tableB’s data but the link used changes based on the field Closed.
Thanks for the help!