0

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?

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by AngelicOne
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.