Hi,

       How to generate a report from multiple tables? For example, students personal details stored in a table and their marks details stored in another table. Register is primary key in personal details table and foreign key in marks details table. I want to take the report based on the register no. Personal details will display one by one like name, address, phone no,... and the marks details will shown by a table from first mid term to annaul exam.

Name:  aaa
Address:  aaaa
Phone no: aaa

                          Tamil    English     Maths    Science    Social Science
First mid term        87       52            75          86               75
.
.
.
Annual                   90        95            99         92                89


How it is possible?