Originally Posted by
Minty
You are close - you don't need the staff name in the junction table, as that can be pulled from the Staff ID.
I would also rename your ID fields as StaffID, CourseID and CSJunctID , as later on you'll have no idea which ID field you are trying to query...
In your combo box set the row source to query staff table, but pull in the First & Last Name as a calculated field and display it, you can also hide the Staff ID number for "prettyness", and sort it by name.
If you get stuck post a stripped down version of the database and I'm sure we can demonstrate the technique.