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 &nbspqbd1,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/
 

Reply via email to