help -> QuerybuildDataSource

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? bcoz when I check the query, after step 2, the query
is correct, inventdim join to inventbatch, but after step 3, seem
inventdim query loose all the join.

I mean, can in Axapta, 2 different table join to 1 main table ?

thanks in advance,
Ton

Messages in this topic (1) Reply (via web post) | Start a new topic

.

Try set fetchmode on QueryBuildDataSources to QueryFetchMode::One2One

On 6/8/07, axaeffect < axaeffect%40yahoo.com.sg">axaeffectyahoo.com.sg> wrote:
&gt;
>
>
&gt;
>
>
>; 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? bcoz when I check the query, after step 2, the query
&gt; is correct, inventdim join to inventbatch, but after step 3, seem
>; inventdim query loose all the join.

--
Max Belugin, http://belugin.info , ICQ:9406811

Messages in this topic (0) Reply (via web post) | Start a new topic

.

You have to set the fetchMode on the child QueryBuildDataSource
objects to QueryFetchMode::One2One - the query will be OK after that

--- In development-axapta%40yahoogroups.com">development-axaptayahoogroups.com,
"axaeffect&quot; <axaeffect...> wrote:
&gt;
> 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? bcoz when I check the query, after step 2, the
query
> is correct, inventdim join to inventbatch, but after step 3, seem
> inventdim query loose all the join.
>
> I mean, can in Axapta, 2 different table join to 1 main table ?
>
>
> thanks in advance,
> Ton
>

Messages in this topic (0) Reply (via web post) | Start a new topic

.