SQL Insert question

[de ware]

Hi,

Trying to insert data in an Database using SQL in VBA.
Let's assume i have two tables:

Books -> columns: description / pages / author
Author -> columns: Author_ID / Author

When inserting a new book the table books (using an xls workbook as interface) the user has a listbox where the possible Authorss are loaded.
So i have the 'Author' as a variable but I need to insert the Author_ID in the table books
How this is don in SQL language?

I guess the solution might be something like using 'INNER JOIN' which works for making selections but I cant't find how.

 

[Larry Haydn]

Something like this?

INSERT INTO BOOK (Description, Pages, Author) VALUES ('" & CellA & "','" & CellB & "'," & (SELECT AuthorID FROM AUTHOR WHERE AuthorName='" & CellC & "');