timetable

[Gruung]

Right I have no idea how to go about doing this so I am open to any suggestions.

At my school the timetable is split up into blocks, there are 5 blocks, block A, B, C ,D ,E. You can do one subject per block. Currently I have a table:

StudentID
BlockID
SubjectID

So the user will fill in what subjects the student does in what blocks. What is gonna happen is there will be a standard timetable that the user will fill in, saying what blocks are when (I dont have a way of doing this yet). So e.g everyone will do whatever subject they do in block A on monday moring at 9:00. I want a command button so that when clicked it will see what subject you do in block A, and fill out the timetable, all the areas that are block A it will replace with biology. And all the areas with block B it will replace with Spanish. It gets more complicated but I think once I have some ideas i will be able to sort out those problems.

I hope it is clear

thanks any help would be appreciated

 

[rich.barry]

Watch me get shot down here, but......I reckon Excel does this job far more quickly (i.e. 10 min vs hours).
Have a look at the attached example, which you can probably tidy up to suit your purpose.
Tools, Scenarios can be used to store individual TimeTables.

 

[Gruung]

so what link my database to excel, how do you do that? Seems like an ok example, still got to understand it fully though...but my slow mind will get there lol.

 

[Gruung]

Right i have most of this working, it links to the database but one quick question, why do you refer to B8 or B9 or B10 or B11 in the students bit of the spreadsheet, i dont understand that bit.

thanks

gruung