Search results

I have found my way.Thanks for all that help me .

Please can you correct me if I am wrong I'll design a table of teachers with primary key teacherID then subject with PK subjectID classes with ClassID days with DayID periods with PeriodID Now Primary TeacherId with foreign Key subjectID , classID,DayID and PeriodID Then Primary subject ID...

Thanks GinaWhipp for this , however, I'm new and just start using access. Then I need little help to develop the project. My Question only how Do I do a forum that has a drop-down box which has the day and period of the class and display the teacher's name only as a result. If someone can only...

It's ok if someone can do this for me.

OK Mile-O your example was great but please modify it little to have all days and periods 5 days with 7 period each and an query to display the name of teachers that don't have class on this day with this period. please i'm novice in access . Sorry if I don't understand your expressions.

Please if someone can help me with example . Thanks in advance

Thanks alot Mile-O for the example I tried to see your example and explore it it solves half of the story the timetable doesn't depend on date . it repeated every week with the same classes . I need a report depend on a query when i open the report it asks me first which day you want and...

Thanks alot for this

Please i am new to access and cant see images cause i have less than 10 posts Please explain step by step

I am using access 2007 and my table structure that is Teachers have many classes during the day and week I put tescher name the put sun1 sun3 etc for their classes Now i want a query and report to display who are free in this day and this period Hope this clear

Hi mates I will explain the problem in easy way I have a table query this table has schedule of classes during the week for example in Sunday i put sun1 sun2 sun3 sun4 upto sun7 sun means sunday and 1 means period 1 now i have a report to display who of the teachers arent have classes in sun1...