DamoTheOmen666

ok, so i'm back, and i need help in creating a timetable of each student's subjects in the student table what would be the best way of doing this?

Ok, I'll be back :') Thanks for everything!

You are an absolute genius I may need to re-visit because i need to make it so it automatically forms a timetable for each student, although i think i know how i can do it. If i come back where should i post- this thread or start another one? Once again thanks for all your help!

Ahh ok i understand, The validation didn't do anything, i can still enroll two clashing subjects for one student

Where do i put that validation code? In an existing field or a new one? So It's distinguishing between lessons for each student with the Global record entering into the field? You know the relationship diagram, when each table instance is duplicated (Lesson3 etc) is it actually making a temporary new table? or is it just to define other relationships to the original existing table?

Ok thanks, Does it not show an error when two subjects clash? Could you explain to me how everything works and why everything is linked the way it is? I'm trying to understand this, sorry for asking so much

here you go i havent done much validation or design yet Database.zip

Ok everythings set up When i enter two subjects that clash nothing happens?

Ok I've done the conditional formatting, and i know how to do OnRecordLoad, can you give me an example of a code that will populate the gStudentID field? sorry :/ I tried to do it by using a replace field function specified to the StudentID But when the script loaded it asked me whether i wanted to replace it but when i looked it was blank

Right i've done everything, but i need help with these parts The OnRecordLoad Function isn't there, and how do i apply conditional formatting?

Yes, that's right Although the main subjects would be double or triple So Monday Lesson 1, 2 & 3 And Thursday Lesson 4 & 5 Yes the student attends all of the 5 lessons If this helps Normal timetable would be- 8:45 - 10:45 2 lessons then 15 minute break then 11:00 - 12:00 Lesson 3 then 12:00 - 13:00 Lunch then 13:00 - 15:00 lessons 4 & 5

Monday to Friday with 5 lessons per day One Subject has 5 lessons throughout the week

Thankyou very much!! Also, I'm trying to make a table of Days and time periods for each subject so that the system flags up if two chosen subjects clash in the timetable, what would be the best way to do this?

Basicly I'm computerising a school system. I've got Student and Subject table, and also a StudentSubject table that links the two so many students can take many subjects. I've got a portal showing the records linked to it through StudentID to SubjectID The portal only shows records when i manually input data into my StudentSubjects table Is there any way i can create a new record with the same StudentID in the StudentSubject Table from my Student Form to prevent me having to go to the StudentSubject table and re-entering the StudentID for every subject each Student is taking? Sorry if that made no sense, but please help!