m:n forms

  • Thread starter Thread starter Filip
  • Start date Start date
F

Filip

I would need hint with creating forms where there is a subform which is in
the m:n relation with the main form. Both forms are based on tables, which
are in the m:n relation (via third table with two 1:n relations) but I am not
able to bind the corresponding records from the subform to the related record
in the main form.
Eg. Two tables, projects and employess, where 1 project may be addressed to
more employees and vice versa.
 
Typically what's done is bind the parent form to a query based on the
projects table, and bind the form being used as a subform to a query based
on the intersection table (your "third table"). In that second form, use a
combo box that has a query based on the employees table as its RowSource.
 
Back
Top