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), 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. > > --- In > Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > "kamal_ec" > <[EMAIL PROTECTED]> wrote: > > > > 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-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > "axaeffect" > > <axaeffect@> wrote: > > > > > > Hi all, > > > > > > how to join 3 tables in querybuilder? > > > > > > for example I want to join InventDim Table with inventBatch and > > > WMSLocation > > > > > > In my logic should be like this > > > 1. first Query is InventDim > > > 2. join InventDim to InventBatch > > > 3. join inventDim again to WMSLocation > > > > > > is that correct? > > > > > > thanks in advance, > > > Ton > > > > > > > > [Non-text portions of this message have been removed]
