Combining CustTable? Do you mean SalesTable? Why do you want the dataSource to be add dynamically instead of design it in the form?
--- In Axapta-Knowledge-Village@yahoogroups.com, Syner P <[EMAIL PROTECTED]> wrote: > > Hi, > > Is it possible to add an additional datasource to the forms query and filter the form without joining them in the form.For example filtering the form ProdTable with CustAccount via SalesId without combining CustTable. > > I tried the following code in form ProdTable but it didn't work. > > this.query().addDataSource(tableNum(SalesTable)); > qbr=this.query().dataSourceNo(2).addRange(fieldNum (SalesTable,CustAccount)); > this.query().dataSourceNo(2).addDynalink(fieldNum (SalesTable,SalesId),fieldNum(ProdTable,InventRefId)); > > Any help appreciated. > > Syner > > > ______________________________________________________________________ ______________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs > > [Non-text portions of this message have been removed] >