I AM IN A SCHOOL AND NEED TO UPDATE STUDENT RECORDS. THE STUDENT TABLE TELLS ME WHICH YEAR THE STUDENT STARTED. THE TRANSCRIPT NEEDS TO HAVE A COLUMN BY YEAR AND ROW BY CLASS TYPE. DUPLICATES CAN OCCUR ON TYPE (EX. MORE THAN 1 ENGLISH CLASS IN A SINGLE YEAR). I NEED TO UPDATE TRANSCIPTS FROM A CLASS SCHEDULE AT YEAR-END UPDATING THE TRANSCRIPT IN PROPER COLUMN AND ROW. CAN'T FIGURE OUT HOW?
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
UPDATE A TWO DIMENSION TABLE
- Thread starter RSTEVE
- Start date
If you're asking about a structure that already exists, need name of tables and fields to write a query. If you are trying to build something that can handle this, try:<br>
<br>
tblStudent: StudentID, etc.<br>
tblClassType: TypeID, Type Description<br>
tblClass: Class ID, TypeID, Class Description<br>
tblPeriod: PeriodID, description (semester & year or whatever)<br>
tblSchedule: ScheduleID, ClassID, PeriodID<br>
tblTranscript: TranscriptID, StudentID, ScheduleID<br>
<br>
This will be a very flexible format. Better than putting Class Type in the Transcript when you are really are probably tracking Class. You could just show Class type on a report or whatever.<br>
<br>
tblStudent: StudentID, etc.<br>
tblClassType: TypeID, Type Description<br>
tblClass: Class ID, TypeID, Class Description<br>
tblPeriod: PeriodID, description (semester & year or whatever)<br>
tblSchedule: ScheduleID, ClassID, PeriodID<br>
tblTranscript: TranscriptID, StudentID, ScheduleID<br>
<br>
This will be a very flexible format. Better than putting Class Type in the Transcript when you are really are probably tracking Class. You could just show Class type on a report or whatever.<br>
- Status
Similar threads
