Forms and Many-to-many Relationships

[Guest]

Hi,

I'm using Access 2007 and a couple of older but excellent books (Using
Access 2002 and Developer's Handbook 2002) with no success, so I come to the
experts.

I have 8 tables. Two (Table A and Table B) are related in a many-to-many
relationship through Table A-B. I'm trying to create a form (Justified)
based on Table A data with a subform of associated Table B data (Datasheet).

I have tried a variety of approaches, but must, in the end, admit to being
clueless as to how to accomplish this.

I'm looking for an information source - preferable step-by-step instructions
so I can learn it by doing it.

Thanks for any help.

 

[Guest]

Did you try using the subform wizard?

-David

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I did, but not with a query (which I have now just done successfully.) Thanks.

 

[Guest]

That's a very kind-hearted thing to post! I'll take a look. Thank you.