My database requires some many-to-many relationship. For example, Table1 = Case and Table2 = Suspect. Between them, i've created Table3 = Connecting Table.
For the input process, i would like to do it semi-automatically.



I've created a form with two sub-forms which contains Table1 and Table2. Once the user filtered both sub-forms, how can i make access input both Primary Keys of the filtered data to the Table3?