Solved Many to many (1 Viewer)

Romio_1968

Member
Local time
Today, 09:51
Joined
Jan 11, 2023
Messages
126
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

Nifty Access Guy
Staff member
Local time
Today, 07:51
Joined
Jul 9, 2003
Messages
16,418
You may find this explanation of "Many to Many" useful. It also includes YouTube videos:-


YouTube:- No 1 of 3

 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 02:51
Joined
Feb 19, 2002
Messages
43,720
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.

 

Users who are viewing this thread

Top Bottom