I would make your primary datasource the transactions table, then secondary datasource, the employee table.
--- In Axapta-Knowledge-Village@yahoogroups.com, "dantinada" <ananth_mist1...@...> wrote: > > Hai friends > In Ax, for a report for one Unique primary key how can I get its related > data lines.(I linked data sources too using relation) > > Ex: for an EmpID (from Emp table)related transactions (from Transactions > table)I have to get as follows. > > EmpID transactions > 1201 25000 > 45000 > 7500 > > Please help me, you can ask me if u can't get this problem clearly. >