Combo Box on Main Form

[armyofdux]

I have a combo box on my main form. Main Form is titled Student Data Entry with respective personal data for said student. This combo box has the class pertinent info organized and sorted in a different table title Scheduled Courses. They have an autonumber Primary Key with a respective ID provided against each course. The combo box points to the table so it draws all the listings of the respective courses. I have a sub form built underneath it to populate the course data



When I get new students in, or I want to modify said student's course schedule I want the subform to show the course they are assigned to. I can get the combo box to save that Course ID but I can't get the subform to populate it. I am missing the connection somehow. Point me in the right direction?

[June7]

Need to review form/subform structure. If you want to provide db for analysis, follow instructions at bottom of my post.

[armyofdux]

Registar Database Operations San.zip

Attached is a sanitized db with the subform shown.

I would like the dropdown of schedule Id to populate the subform at the very bottom with the respective dates.

[June7]

SSN in Booking table is linked to RoomNum in StudentData table.

Why is all that student info duplicated into Booking?

Rooms table should not link to both Booking and StudentData.

RoomNum should not be the primary key in Booking table, BookingID should.

Can room number be repeated between buildings - will there be a room 1 in each building? Don't save RoomNum and Bldg#, save Room ID.

Advise no spaces and special characters/punctuation (underscore is exception) in naming convention. Better would be BldgNum or Bldg_Num.

There is no Student Data Entry form, there is Soldier Data Entry.

The Master/Child Links properties are not set for the CourseReservation subform.

[armyofdux]

SSN in Booking table is linked to RoomNum in StudentData table.

Why is all that student info duplicated into Booking?

Rooms table should not link to both Booking and StudentData.

RoomNum should not be the primary key in Booking table, BookingID should.

Can room number be repeated between buildings - will there be a room 1 in each building? Don't save RoomNum and Bldg#, save Room ID.

Advise no spaces and special characters/punctuation (underscore is exception) in naming convention. Better would be BldgNum or Bldg_Num.

There is no Student Data Entry form, there is Soldier Data Entry.

The Master/Child Links properties are not set for the CourseReservation subform.

Ok I corrected the link SSN In RoomNum in StudentData

The Student Info is Duplicated in Booking so I can hold rooms to students during their attendance. Is there an easier way to do this?

I removed the link between Rooms tbl and Student Data

I made RoomNum the new PK

Yes the room number can be repeated between buildings. I used a combine function in excel to marry the building with the room to look like this... 698 (BLDG) 101 (ROOM) into a combined form 698101

I changed the naming convention as suggestd with the underscores

You are correct I meant Soldier Data Entry

Not sure where or what to set the properties for the CourseReservation subform.


Thanks for your help... I am getting there.

[June7]

Should only save student ID (SSN or whatever is PK in student table) into booking table, not all their related info.

The Master/Child Links are properties of the subform container control and are on the Data tab of Properties Sheet.