How to update old DB to New DB?

sweetummy,

You are STILL to focused on the report and not paying attention to the
tables. Think of it like this...

Completed Database = House
Tables = Foundation
Queries = Rooms
Reports = Decor

You are so focused on the *Decor* that you don't realize you have built your
*House* on a POOR *Foundation*. So you need to refocus on the *Foundation*.
You have redundant fields (same fields showing up in more then one table).
That goes against normalization. So PLEASE go over the table set-up and
either redo or explain why you feel need redundant fields/data in more then
one place. Why is StudentID in the Areas tables when it will relate back to
Students table via the AreaID?

As a side note, stop using your reall eMail address or you will get alot of
unwanted mail. Spammers harvest here!

--
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,
I must thank all of the great guys over here..supporting me right from
the intial stage..
I read tutorials regarding to your links given, they are simply
amazing and very helpful..

Coming to my database I have cut down all the tables according to
report demands..
1. We need reports according to the student id, by their course and by
their area they which belong by the academic year.

I understand that, the data should not be redundant should be unique
and should be related to each other table what we have logically in
our database and according to our demands..

So i have reduced to 3 tables.. namely
1. tbl_StudentDetails
2. tbl_courseDetails
3. tbl_AreaDetails

please look at this relationship and their fields in it.. i have
taken.. I thought a student is studying a so and so course and belong
to so and so area, here the only key is Student id so i make it as a
primary key and auto key column is the primary key for all these three
tables i have taken over here...

http://sites.google.com/site/gsvfilm...attredirects=0

thank you once again.