Insert into Many-To-Many Tables ?

Question

I have below tables:

Books               Auther               Book_Auther
-------                --------               ----------------
BookID             AutherID            Book_AutherID
Book_Name     Auther_Name     BookID
Book_Pic                                    AutherID

I have one form to enter books details Book_Name (Text box), Book_Pic (Upload), Auther_Name (drop down list)..

How the Insert command should be in the Save botton?
How the Update command should be ?
How to Upload book pic?

Your help is highly appreciated.

---

Nothing is impossible

Answer 1

Your question is more about application design. Your tables appear to be properly designed to accomodate the M-M relationship between books and authors.

According to your information, author names are stored in a drop-down list. How does the user enter a *new* author not already in the list? Did you mean combo box?

You have a textbox for book title entry. How do you prevent users from entering a duplicate title with a typo? Further, book titles are not unique in the universe of books. Should you consider use of ISBN as the primary key to prevent duplication?

That said, according to your information, the author row will already be present, so your should first INSERT the new book row, then insert the needed intersection row.

 

Answer 2

Thoughts and notes:

1. Books can have more than one version. If they to be logically grouped, the picture would go in another TABLE.
2. A library can have more than one copy of the same book. If they to be logically grouped, it requires another TABLE.
3. "Auther" in English, is spelled "Author".

Answer 3

Thank youvery much for your help..!!

---

Nothing is impossible