problem with working on form with fields of many to many relationship tables

jamilmurad

New member
Local time
Today, 03:51
Joined
Oct 24, 2012
Messages
9
hello
hi guys
this is my first thread.actually i have a problem.the problem is that i have designed a database for my academy i have to save records of teachers of academy and courses taught in academy as well as records of batches of those courses taught by teachers, so i have made 3 tables which are
courses, teachers, and batches. i have a many to many relationship between teachers and course through the junction table batches but the problem is that i can't use the fields of all three tables in a form."can not update records" error is teasing me. please help.
thanks
 
No, you can't use all 3 tables in a single form. If I read your description correctly, you should have

1. Main form based on Courses.
2. Subform on Courses form for Teachers
3. Subform on Teachers subform for batches.
 

Users who are viewing this thread

Back
Top Bottom