hi
I have 2 tables . One tabel has fields Code,Name . Second table has fields Code,Name,U_Amt
I want to display matrix which should display all Code,Name from first table and U_amt of second table against the first table Code in the 3rd column.
Data is like this
First Table
A01 TypeA
A02 TypeB
Second Table
A01 A01 100
A02 A02 500
So matrix should be like this
A01 Type A 100
A02 Type B 500
Thanks