Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Forms and Many-to-many Relationships

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Minding - 07 Nov 2007 17:53 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.