Originally Posted by
June7
The db has only one form - frmTeacher. No need to include table School in the form RecordSource. This form will allow you to add new teachers to Teacher table. You can have a subform bound to Junction with a combobox for selecting bookings. A different approach is to have main form bound to Booking and subform still bound to Junction with a combobox for selecting teacher. You can have both arrangements in the db and enter records according to the situation. The first will allow you to enter multiple bookings for one teacher, the second will allow you to enter multiple teachers for the same booking.