Many to Many

[Emma]

Hi I have a database with a passenger table with passenger ID as primary key,
and a trip table with Trip ID. I want there to be many passengers on a trip
and many trips for one passenger. I tried adding an Inbetween table with 1 to
many relationship to both tables but I'm not sure where to go from here? How
do I create forms to gather this information?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImplementingM2MRelationship.mdb" which illustrates how to do
this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=342

--
--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

 

[Emma]

Hi Roger,

That helped with one aspect the one trip with many passengers but how do I
create the opposite form one passenger many trips?

 

[Roger Carlson]

You create a second form with passenger as the control source for the main
form and a query joining the other two tables as the control source of your
subform.

--
--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