List boxes

[ChristianX]

hey all,
i have connected to my database via OLEDB setup. As mentioned in a
previous post i want to associate a test with a book when i create it.
Test and book have a seperate table in the DB, with test table having the
bookID that it relates to.

What i want to achieve is that when the user clicks on new test it will
bring up a list box with all the books in the system allowing them to
choose one. However how do i do this? Im having trouble figuring it out.

As an afterthought to this, ideally the user wil select the book title
they want to associate the book with, however in the test table all i wil
be wishing to store here is the bookID and not the title. How could i let
the user select the book title but write the bookID to the test table
instead?

DB TABLES:

TEST
TestID
TestName
CreationDate
BookID

Book
BookID
Title
Publisher


guys would be immensely grateful if one of yous could give help here.
thanks,