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.
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.