Hi, I'm going round in circles with this problem and I need some help, please. I am creating a many to many relationship in my Staff --- Courses database. I have a Staff table with StaffID as the Primary key, a courses table with CourseID as the Primary key and a Junction table with its own ID as the Primary key and StaffID and CourseID as the two foreign keys. I have created a main form with Staff names etc from the Staff table and a sub form from the courses table and Junction table. The courses titles (only 6 of them) are in the form of a combo box. When I cycle through the form with existing records it all works fine but whenever I try to add a new record it will allow me to add a new staff name but the course form won't allow me to choose an existing course and assign it to the new staff member. The Parent/Child links seem OK - at least it generates a member of staff with up to 6 courses assigned to them as an existing record. It just won't accept any new records in through entry in the sub form.