Search results

Wow, that worked great. I have reformated the database based on some of you criteria, and it is working out well. Thank you so much for your help, it is working out well. :)

The first half looks great, that should work just fine. The second half may require reworking the main form. What the main form show is the instuctors name, office location, phone, e-mail, and department. This is data from an instructor table. The subform is the room, class id, day, time, and...

I hae a db that keeps track of classes, insturctors, and the times and days the class is taught. I have a table with all the days of the academic week (M, T, W, R, F, S) set up with an identity field so I can sort them in this fashion. Classes can be held on one day of the week, and most are...

The first form (main) has the insturctors name, phone, deparmtnet, and other location info. This information comes from a instructor table, that has a relationship with the class table (the classes they teach). The main form also has a combo box with a list of semester codes that is drawn from a...

Thanks for posting so quickly Alex, but that doesn't seem to work. Maybe I can explain further. The first form (main) has the insturctors name, phone, deparmtnet, and other location info. This information comes from a instructor table, that has a relationship with the class table (the classes...

I have a main form with information about instructors, and departments they work in. I also have a subform that shows the courses they teach, and the information about the courses. I have created a combo box that draws its info from a table. This combo box has a list of semester codes, the sam...