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]