[Axapta-Knowledge-Village] Re: joining 3 tables

Hi Agus, Thx.. IT WORKS. !!! :D --- In Axapta-Knowledge-Village@yahoogroups.com, "Agus Riyadi" <[EMAIL PROTECTED]> wrote: > > Hi Ton, > > Set the properties FetchMode to 1:1 to the second and third data source. > > Regards, > > Agus > > > > On 6/8/07, axaeffect <[EMAIL PROTECTED]

Re: [Axapta-Knowledge-Village] Re: joining 3 tables

Hi Ton, Set the properties FetchMode to 1:1 to the second and third data source. Regards, Agus On 6/8/07, axaeffect <[EMAIL PROTECTED]> wrote: > > hi kamal, > > Thx, I already know the relation, the problem is when I use > QueryBuildDataSource, after I create the first Query (InventDim), ad

[Axapta-Knowledge-Village] Re: joining 3 tables

hi kamal, Thx, I already know the relation, the problem is when I use QueryBuildDataSource, after I create the first Query (InventDim), add new datasource (InventBatch), linked them, and add new datasource again(WMSLocation), when I link it to the first query, seems can not work. rgds, Ton.

[Axapta-Knowledge-Village] Re: joining 3 tables

Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Villag

AW: [Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ?

nerstag, 7. April 2005 03:55 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ? Hi Jesper, Thanks for your reply, but actually I already tried that and result is also wrong. If I debug it, the result query ->

[Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ?

Hi Jesper, Thanks for your reply, but actually I already tried that and result is also wrong. If I debug it, the result query -> qbds = SELECT * FROM InventJournalTrans qbds1 = SELECT * FROM InventDim WHERE InventJournalTrans.InventDimId = InventDim.inventDimId AND ((InventLocationId = 01))