[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

> hi >  > I have never tried the other way but may be because addlink criteria is fieldnum parent table - field num child table ? >  > regards >  > harry > Exactly.  In the addLink() method the parent field should be the first parameter, the child the second.  You have them the wrong way

Re: [development-axapta] Re: Joining 3 tables with QueryBuildDataSource

hi I have never tried the other way but may be because addlink criteria is fieldnum parent table - field num child table ? regards harry Anton Tjiptadi <[EMAIL PROTECTED]> wrote: Hi andrew, thanks I tried your way, but first it 'cause error in the first QBDS in the QueryRange, i

[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

Hi andrew, thanks I tried your way, but first it 'cause error in the first QBDS in the QueryRange, it says "Invalid Range", and then I switch the table order so it looks like this : qbds = q.addDataSource(tablenum(InventJournalTrans)); qbds1 = qbds.addDataSource(tablenum(InventTable))

[development-axapta] Re: Joining 3 tables with QueryBuildDataSource

--- In development-axapta@yahoogroups.com, "Anton Tjiptadi" <[EMAIL PROTECTED]> wrote: > > > Hi, > I want to join 3 tables with QueryBuildDataSource (QBDS), the > statement is like this : > > ...the goal is, I want join table InventJournalTrans to InventDim > with key InventDimId and joi