timetable

[Guest]

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

StudentI
BlockI
SubjectI

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 clea

thanks any help would be appreciated

 

[Jonathan Parminter]

-----Original Message-----
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
.

Hi Ranak,
I'm wondering whether you may not be tackling this
the 'best' way (... if anyway can be considered best).

What's the relationship between the tables? For example if
it's one subject for many blocks. Have a subject main form
and add blocks in a subform. Then at a glance you can see
all the times a subject taught.

You can have upto 3 levels of form. So that you could for
example have the subject main form with a block subform
that contains a student subform. The outer forms must be
in single form mode, whilst the inner most subform can be
any form mode.

If your still set on the approach you posted use online
help to lookup update sql's

Luck
Jonathan