For Eg I had a student table and an activity table. 1 student can have many activities and 1 activity can have many student. This make up a many to many relationship.
I had a insection table Student_Activity. When i am creating my subform i am using the student table as the subform and activity table as the form. However I am not allow to have duplicate key in my parent key. So i should be using the insection table right?
Another thing is how do i add the parent key then cos if i se the intersection table value i should add the parent table first right?
Also do i find the form properties and change the default view to continuous forms like what mrtgold has say?