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,

Check out one of these links:

http://www.takempis.com/asplistbox.asp
http://css.ucr.edu/mss/_disc1/00000003.htm
http://www.aspin.com/home/tutorial/database/display/listbox
http://www.faqts.com/knowledge_base/index.phtml/fid/469
http://www.4guysfromrolla.com/webtech/tips/t011100-2.shtml

Mark.
--- WVerner <w_verner@h...> wrote:
> 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,


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com