Many to many relationships (I think)

[tjnichols]

I have a database that has classes and contacts (students). Each student could attend many classes and each class could have many students. The problem is that I am a complete loss as to how to set this up.

I have attached my database so you can see it.

Thanks!

 

[rodmc]

junction table is your friend, in other words create a table that breaks the many to many down into 2 One to manys

 

[rodmc]

BTW it helps if you can upload in mdb format as not everyone has 2007/2010

 

[tjnichols]

I have tried to save this as an earlier version but Access won't let me. It says "You cannot save this database in an earlier version format, because it uses features that require the current file format." Can someone who has 20007 or 2010 look at this?

Thanks!

 

[rodmc]

this may help, its hard to get your head around at first but once youve got it figured it, its actually quite simple

http://www.databasedev.co.uk/many_to_many_example.html