Solved Many to many (1 Viewer)

Romio_1968

Member
Local time
Today, 08:37
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.
 
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

Back
Top Bottom