Is it possible to develop form with many to many relationship

[Alice]

I have a need to develop a form with 2 tables
having many-2-many relationship. I was wondering
if it could be done in access. If yes, then can someone
please provide some hint.

Thank you in advance,
-Al

 

[Paul James]

Yes, it's possible. Create a form with a Record Source based on one of the
tables (or better, a query based on that table), and a subform whose Record
Source is based on the other table (or query based on the other table).
Here's a quick way to do it:

1. create a form with a record source based on one table; let's call this
frmA
2. create another form with a record source based on the other table; make
this form much smaller than the first form. Call this frmB.
3. open frmA in design view.
4. click on frmB in the database window and drag it onto the Detail section
of frmA.

Access will automatically create the linking relationships between the form
and subform. Since your tables are related on a many to many basis, you can
do this usine either table in the main form and the other table in the
subform.

To read about this in Help, go to the Contents tab and open the topics under
Forms - Creating Subforms. Especially look at "Create a subform."

hth

Paul