Search results

That worked, thanks. In the design view, I now see tblCourses, tblCourses_1, and tblCourseLabs. tblCourses_1 is lined to tblCourseLabs with a one-to-many linked (like in the Relationships window) whereas tblCourses is linked to tblCourseLabs with a simple black line. Is that something to worry...

I am still working on the forms. I have only created: 1. frmRelatedLecturesLabs Form linked to tblCourses, filtered for only lectures. Subform linked to tblCourseLabs; Combo Box filtered to show only labs. I linked between a few lectures and labs. For testing purpose, I wanted to run a query...

I will try this and see what happens. Thanks again.

Let me try to review the required forms: 1. frmRelatedLecturesLabs Form linked to tblCourses, filtered for only lectures. Subform linked to tblCourseLabs; Combo Box filtered to show only labs. Question: How does this relationship come into play since CourseLabID is not linked to a FK? 2...

Please see the attached structure. I am attaching both a PDF of the Relationships and the actual database, in case that makes it easier to read. Let me try to describe the set up here: Courses/Labs: Math 101 English 1 Spanish 2 Math 101 is offered 3 times during the same semester: Lecture 1...

I will work on that...

I think I am understanding the tables and general data model. It's all the required forms I am struggling with.

Thank you. What I did in the mean time, is insert "N/A" when the field was blank. Thanks for the alternative.

Yes, basically each course needs to be associated with the three labs that go with it, and yes some courses are offered more than once. I do need to capture meeting days and time, both for the courses and the labs. I also need to capture compensation information for each...

Clarification: I have three Computer Science 1A: 1. MWF 10-11 2. MWF 11-12 3. TuTh 11:30-1 Each course has three labs: Course 1 (MWF 10-11) has 3 labs: M 11-12, M 12-1, and W 1-2) Course 2 (MWF 11-12) has 3 labs: M 1-2, M 2-3, and M 3-4) Course 3 (TuTh 11:30-1) has 3 labs: Tu 9-10, Tu 2-3, and...

Thanks for the clarification. Some of my courses have multiple iterations, i.e., I have 3 Computer Science 1A courses, each having three different lab meetings (students only choose one lab). Sorry for neglecting to mention that. Can that be accommodated?

By the way, should I force referential integrity on any of these links?

After creating a subfrom linked to tblCoursesLabs, when I went back to the look at the Relationships, a new table has appeared: tblCourses1. It is now linked to tblCoursesLabs and tblCoursesLabs1 is not linked to anything anymore. I am still having trouble completely understanding...

I think I am missing something. Both fkMCourseID and fkLCourseID in tblCourseLabs are linked to the same pkCourseID in tblCourses? How do I accomplish that? Add tblCourseLabs twice to the Relationships windows and then link fkMCourseID in one and fkLCourseID in the other? Since I now have two...

Thank you. This is really helpful, and I look forward to playing around with it.

Thank you. I will try to implement this. A couple of questions: 1. I don't see tblCourseLabs or fkCourseLabID anywhere in the tables that create the different combinations: tblCourseSections and tblCourseSectionPeopleRoles. How does that work? Don't I need to fkCourseLabID somewhere? 2. How...

I am building a database that contains information relating to instructional staff in my program: instructors, teaching assistants, readers. The database helps keep track of contact information and generating contracts. It does not handle enrollment in courses. This is the general structure...

I am using code I pieced together from a few different sources online, but I am having trouble understanding how it works. The main idea is to merge data from an Access query into a Word template. This specific method required me to first set up the mail merge in Word (designate data source and...

And thanks for the cross-posting etiquette info, pbaldy. I appreciate it.

Thank you both!