Apache OpenOffice Community Forum

Hi,
I have the following database
TEACHER (cod_teacher, surname, name)
CLASS (cod_class, year, section, course)
LESSON (cod_lesson, id_teacher, id_class, subject, time, day)
-id_teacher (TEACHER) and id_class (CLASS) are foreign key
-time includes in which time of day (from the first to the fifth) the lesson takes place
-day includes in which day of week (from monday to saturday) the lesson takes place
What i would like to do is a form composed of the following data
-two text fields (surname, name) in which the user insert teacher's name and surname
-30 combo box (arranged in a grid 5x6) that represent the hours of a week, from whose list you can choose a class
the form should memorize for each lesson time
-id teacher (through the name and surname inserted in the text fields)
-id class (provided by the user's choice that click on one of the 30 combo boxes=
-lesson's time and day, which I guess can be attributed automatically based on which combo box the user's editing
So, if the user edit the first (at the top left) combo box, one row of the tab lesson has always to receive time=1 (or first) and day=1 (or monday)
I hope someone can help me, thank you

I don't think the scheme you show in the form timetable will work, at least not with the data tables you currently have in your database.
I uploaded a revised database. I believe the form timetable3 may be close to what you want to accomplish. I only included 4 days on the form, but it shouldn't be too difficult for you to add the missing days.

awesome, thank you