Ikhiloya Imokhai I think what Olalekan Folayan is trying to say is that, let us say the user can only give the name of the author, in that case how do we get the id of the author from the authors table and use it to create a book.