Many-to-Many Relationships

[African]

I am in the process of designing a database which would allow for easy collection and storage of publications by various Authors. One of the requirements is that they would like to be able to email the form, have the users complete the form and send back, Access allows the option to email the form so that the user can complete. I created a table with all the required fields to use for the form. I emailed one of the form to myself for testing, I completed it and sent it back, it said the data was successfully added to the database, but when I checked the database, no information was added.



Another one on my approaches was to create separate tables to handle the different categories, since an individual could be in more than one category, then generate a query which would capture all the information. I need to know how to handle the many-to-many-relationship so that I can effectively capture everyone information. I am working with 8 tables.

[RuralGuy]

m:m relationships are usually controlled with a junction table that YOU maintain. It has the PrimaryKey from both tables in a record. Typically you would deal with each side one at a time.

[African]

I do have an associate table created as well and I tried creating a query which would display all the results from the various tables but only 1 record is displaying. I am not sure what I am missing.

[orange]

It might be helpul i you were to post a jpg o your tables and relationships.

or info on Many to Many, here is a youtube video

https://www.youtube.com/watch?v=7XstSSyG8fw

[African]

I have attached a pdf of the relationships. I have also watched various video with the many-to-many relationships, but they only deal with 2 tables.



Relationship schematic.pdf

[orange]

And what exactly does this pd represent?
What are the subjects involved? and how do they relate?

This tutorial may help you get the info organized.
http://www.rogersaccesslibrary.com/T...lationship.zip

[African]

I am not sure that I understand the question, but I will do my best to explain. We have a number of Researchers who may either write a book, book review, chapter, occasional paper, journal etc. A Researcher may fit into one or all of the categories mentioned. The idea is to capture all of the work done by the researcher. I created a table for the Author and tables for the different categories, then placed the different primary keys into the Associate table, which is what I thought the pdf. showed.

the videos that I saw included the primary key from the different tables into one Associate table, which is what I did. I guess I am going about it all wrong. I am now sure how I could attach the mdb. format

[orange]

This tutorial
http://www.rogersaccesslibrary.com/T...lationship.zip
is a pdf. It has a sample with narrative and some diagrams, and walks you through a process leading to table design and relationships. The finalized data model/solution is given along with all intermediate steps.

[RuralGuy]

I am now sure how I could attach the mdb. format

First Compact and Repair the db. Then Zip it up. then when you post, go to advanced and scroll down to Manage Attachments.

[African]

Since reading your article Entity Relationship I have made changes to the tables, I have attached the tables along with the document outlining the different categories.

Thanks

African

[African]

I am still trying to fully sort out the various many-to-many relationships, any assistance would be greatly appreciated.

African