Hi..I'm a newbie and need some help from the expert.Below is a simplify exa= mple for my problem.
I'm using three table: Table1 - id,name,age Table2 - name , address Table3 - age , status Inside Fetch Method: Query q =new query(); QueryRun qr; QueryBuildDatasSource  qbd1,qbd2,qbd3; QueryBuildLink qbl1,qbl2; Table1 _table1; Table2 _table2; Table3 _table3; qbd1 = q.addDataSource(TableNum(Table1)); qbd2 = qbd1.addDataSource(TableNum(Table2)); qbd2.joinmode(JoinMode::InnerJoin); qbl1 = qbd2.addlink(FieldNum(Table1,Name),FieldNum(Table2,Name)); qbd3 = qbd1.addDataSource(TableNum(Table3)); qbd3.joinmode(JoinMode::InnerJoin); qbl2 = qbd3.addlink(FieldNum(Table1,Age),FieldNum(Table3,Age)); qr = New QueryRun(q); while(qr.next()) { THIS IS THE PART THAT I'M NOT SURE.I WANT TO USE ELEMENT.GET AND ELEMENT.= SEND. I HOPE YOU GUYS CAN FILL THIS PART } I want the report to look something like this: ID NAME ADDRESS STATUS Thanx in advanced,Bye. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/