sweetummy,

You have a few issues with your tables... No Primary Key's, field names
that are Reserved Words, etc... So here goes nothing.

Your tables are not set for the benefit of your forms or your reports.
That's what queries are for. Your table structure should look more like...
(The *(???)* means, I have no clue what that is and why that is in that
table.)

tblStudents
sStudentID (PK)
sFirstName
sLastName
sSex
sCommunity (???)
sVillage (???)

tblCourses
cCourseID (PK)
cCourse
cBranchID (???)
cCourseTypeID (FK)
cGrantPerYear (???)
cRsInWords (???)

tblColleges
cCollegeID (PK)
cCollegeName
etc...

tblCollegeCourses
ccCollegeCourseID (PK)
ccCollegeID (FK)
ccCourseID (FK)

tblCourseEnrollment
ccCollegeCourseID (FK)
ceStudentID (FK)

tblAreas
aAreaID (PK)
aRegionBelongs (???)
aRegion (???)
aArea

If you don't understand the above then have a look at...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

http://www.databasedev.co.uk/table-of-contents.html

For a complete list of Reserved Words see:
http://allenbrowne.com/Ap****ueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"sweetummy" wrote in message
...
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..