Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Relationships Question
well ... i finally got the go ahead! thanks for all the advice! So from many different tables for many different semesters I went to one single table for all students with an additional column for describing the semester ... I also made the database first normal by creating a different table for...- VickAgnes
- Post #9
- Forum: Microsoft: Access Other topics
-
Relationships Question
I see and understand the point that all you enlightened people are trying to make ... It's just that this is the way that it's being done historically ... just data entry ... no forms, no reports, no queries ... just basically data being stored and using mail-merge in word to print out simple...- VickAgnes
- Post #7
- Forum: Microsoft: Access Other topics
-
Relationships Question
well they don't have the same data ... just the same fields ... so i have a table by the name of the semester having the same structure as the previous semester table but different data (since each semester, different people get admitted ... unless of course a previous semester guy doesn't...- VickAgnes
- Post #3
- Forum: Microsoft: Access Other topics
-
Relationships Question
Hi, I have a database that has around 12 tables. All these tables have the same structure (same fields) ... its actually an academic database with a table containing student info ... one for every semester ... What is the relationship that I should use to define these tables?? - Vick- VickAgnes
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
