Hi Özcan, You can use maps in Form datasource... Try a create a map that works as what you want and drag - drop that map to Form datasource...
Best regards Burak 2009/7/17 Özcan Ayyıldız <ayyildizoz...@gmail.com> > > > 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 > >