Hi,
Can anyone point me in the right direction.
I currently use excel to plan classes for a year in advance.
Row Headings = Student name, Column Headings = Date, Cross Ref = Subject
There is only 1 subject per week so that would be 52 entries per student - easy in excel just a cross in a box.
How would I do this using Access.
I have database with separate tables for studentInfo, SubjectInfo but with the table I have created,
StudentID---WeekNo---Subject
For 100 students would mean 5200 entries if I wanted to plan a year ahead.
I'm sure I must be going about this the wrong way!
Any help would be greatly appreciated.