Reply to thread

Message: [QUOTE="Joy, post: 3485607"] Hi - [This message was previously posted to microsoft.public.access.forms, but no one has replied yet, so I posting in the queries NG.] To explain, briefly, I am dealing with 4 tables: Instructor, Course, Instructor Course Expenses, and Instructor Course Expense Details. The Instructor Course Expense record has the total expense for the instructor teaching 1 course on 1 course start date. The Instructor Course Expense Details record has expenses for each day. Here are the keys to the tables: ------------------ Instructor -- Instructor ID Course -- Course ID Course Number Course Start Date (There is1 record for each instance of a course - e.g., course 208 could be offered on 5 different dates) Instructor Course Expense -- Instructor Course Expense ID Instructor ID (FK) Course ID (FK) Position ID (FK) (There is 1 record each time an instructor is assigned to teach a course on a start date) InstructorCourseExpenseDetails -- Instructor CourseExpense ID (FK) InstructorCourseExpenseDetailsID (1 record for each day of the course) One instructor can teach many courses. One course/course start date can be taught by many instructors. Synopsis: ----------- The first thing that happens in the program is you use combo boxes to assign an instructor to a course (with unique course start date) and also select the position from a combo box. This creates a new InstructorCourseExpense record. OK. Then I want to find the same record, by asking the user to enter an InstructorID and CourseID on another form. It would be nice to display the instructors name and the course name on this form, after the user selects from the combo boxes. The way it works now, is, after you pick an instructor, only the course/course start dates that he has been assigned to teach show up in cboSelectCourse. So I hope that the search will always be successful. Then I guess press a button or (use cboSelectCourse_AfterUpdate) to open another form. This will be the requested InstructorCourseExpense record, and on this form there will be a subform where Expense Details can be filled in. So if someone could give me directions - I would be so happy! I am sort of part way there...but it's hard to get my head around everything Access is capable of. Thanks! Joy [/QUOTE]

Verification