Member Avatar for AngelicOne

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
  • 73 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by AngelicOne
Member Avatar for AngelicOne

Foreign key necessary?

Edited by AngelicOne because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.