Hi ,
thank you for replying me..

Yes, thats why i've started renewing the database to new.. even that
too useful some extent... we used to call that data by mail merging
the each table in ms-word. so it would be easier for us to distribute
the reports to the areas.. but its very hard to calculate the
expenditures and other advnced features..

thank you for your valuble tip.. i have made synchonised the required
fields to 3 tables..

1. Students table.
subform table.. (inclusive course details)
2 Course Table
3. AreaRegions Table..

the tables are related logically according to reports how we want..
you can see the picture here..

http://sites.google.com/site/gsvfilm...attredirects=0
(no need to take risk its simple as photo)

The main form will be like this..
http://sites.google.com/site/gsvfilm...attredirects=0

i got a doubt in main form .... I would like to trim it to some fields
like
trans_id, student_id, course, expenditure only not the whole course
table...

if the user tick the mark one more form should be displayed to enter
the higher education details.. is it better or only 1 sub form is
enough..

as you have seen the data is like a speadsheet , so i would like to
cross tab to suit my database design..

please suggest me..