Ozcan, If you want updated grid with fields that belongs to more than one datasource you should use "inner join". After, add groups to the grid and set datasource properties to child tables (SalesLine and forecast sales).
It's the working solution for InventDim fields in AX grids. If you look at SalesTable form, you see the join type "Inner Join". In the Overview grid of sales lines, there is a group, that has datasource "InventDim". I think, because of inner join requirement, AX uses "AllBlank" instead of null string. It allways use inner join. Another join options doesn't work in this type of grid. I tested this case 5 minutes ago. Inner join is not suitable for your situation. I'm sorry but, "i think" you couldn't create a grid like this. Good luck, Anil OZAY --- In Axapta-Knowledge-Village@yahoogroups.com, Özcan Ayyýldýz <ayyildizoz...@...> wrote: > > i said it before. > i tried all join types and i have already table level relation. > > 2009/7/17 avi choudhury <avi123choudh...@...>: > > > > > > u should give a outer join in the link type property and use table level > > relation between tables. > > --- On Fri, 7/17/09, Özcan Ayyýldýz <ayyildizoz...@...> wrote: > > > > From: Özcan Ayyýldýz <ayyildizoz...@...> > > Subject: [Axapta-Knowledge-Village] Problem of join Datasources on the Form > > To: development-axa...@yahoogroups.com, > > Axapta-Knowledge-Village@yahoogroups.com > > Cc: ozc...@... > > Date: Friday, July 17, 2009, 12:39 PM > > > > > > Hi everyone; > > > > I am experiencing a problem with my newly created form on Ax.40. There > > is one grid on the form, i need to place a lot of fields from three > > different datasources( ReqTrans, SalesLine, ForecastSales) into the > > grid. I don't want use display methods. Because i need to filtering > > and sorting on the fields. > > > > Main datasource to that grid is ReqTrans. I added two relations to the > > ReqTrans table relations for salesLine and ForecastSales . > > There may not be related records on the SalesLine and ForecastSales > > tables. The needed solution is that whole ReqTrans records should be > > seen on the grid, whether or not there is related records on the other > > tables. If there are related records on the other related tables, > > these records should be seen on the grid. > > > > I added three datasources to the form. I set the join source property > > = ReqTrans of SalesLine and forecastsales tables. I tried each > > different types of Join Type of that two tables, but not resulted as > > we need. Only the delayed value results that related records apeeared > > on the grid for the selected row. The values disappeared for the other > > rows. > > The values are not shown for active row as well, when other join types > > selected. > > > > Any idea would be apreciated > > > > Thanks. > > > > Özcan AYYILDIZ > > > > >
