I have two tables from my library database, Book and Author.

My Author table has two columns, Author_ID and Author_Name. Book table has three columns, Book_Title and Author_ID..

I have a checkedlistbox in my form which contains author names being populated by Author_Name. What I need to do is when I add a book and I check an author name and add it to database, it should obtain the author_id that corresponds to the checked author_name instead of the name. How could I achieve this?