Solved Many to many (1 Viewer)

[Romio_1968]

To keep it verry simple, i will describe a process>

I have two tables
1. Book Tiltles. Fields are Book_ID, Title (and some other, not relevant)
2. Authors. Fields are Author_ID, Author_Name

One book may have none (when it is a collective author), one, or many authors
Same author can write one or many books

I need a form (that may contain a subform as well aor any other sollution) to add with the same button clik the title and as many authors are necessary

Ex:
Title: I am tryin to learm Access
Author: John, Doe
Author: Me, Me

I know this is supossed to be a many-to-many relationship, but I don't really understand how to define/realise it
Then, the form itself issue comes

How to create a form that adds the title in the Titles table and the authors in the Author table, or what speciffic steps should I take to acieve this goal.
If I need to create additional tables or queries, please describe

Thank you and please try to me as explicit as you can, like you are guiding a baby, one step at a time.

 

[Uncle Gizmo]

You may find this explanation of "Many to Many" useful. It also includes YouTube videos:-

Many to Many Relationship - Nifty Access

Many to Many Relationship - 3 Video's In their simplest form Many to Many relationships are just two columns in a table. The first column representing one side of the Many to Many Relationship and the other column representing the other side of the many to many Relationship. In this particular...

www.niftyaccess.com

YouTube:- No 1 of 3

 

[MajP]

See example good bookstore, library design
Post in thread 'subforms not updating properly' https://www.access-programmers.co.u...rms-not-updating-properly.326210/post-1860735

 

[Pat Hartman]

Here is a many-many example that shows two methods of showing the relationship. From the employee side, the classes are shown as a subform. From the classes side, the employees are shown in a popup. Both types of views are valid but one might make more sense than the other in any given situation.

Many-to-many example

I added a new version on 1/16/23 so choose that one rather than the old one unless you specifically want the old one. The old zip file contains both A97 and AXP versions of the database. It uses venue booking as the example and shows the relationship from both sides. A venue main form with...

www.access-programmers.co.uk