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.
mscertified - 07 Nov 2007 18:22 GMT
Did you try using the subform wizard?
-David
> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks for any help.
Minding - 07 Nov 2007 18:58 GMT
I did, but not with a query (which I have now just done successfully.) Thanks.
> Did you try using the subform wizard?
>
[quoted text clipped - 17 lines]
> >
> > Thanks for any help.
Roger Carlson - 07 Nov 2007 18:38 GMT
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
this.

Signature
--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
> Hi,
>
[quoted text clipped - 16 lines]
>
> Thanks for any help.
Minding - 07 Nov 2007 18:59 GMT
That's a very kind-hearted thing to post! I'll take a look. Thank you.
> On my website (www.rogersaccesslibrary.com), is a small Access database
> sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
[quoted text clipped - 20 lines]
> >
> > Thanks for any help.