hello, i don't know how to explain that,, but i'll give it a go..

i have two tables :
1- items: which has these columns:
-------------itemid -->Priamry Key
-------------name
-------------price
-------------note
2- bookinfo: which has these columns:
-------------itemid -->Priamry Key
-------------author
-------------edition
-------------publisher

now,, in my application, if the item is not book, then i don't have to add any thing to the "bookinfo" table. but if the item is book then i have to add a row to the "bookinfo" table.. my problem now,, how do i relate to bookinfo table, i mean after i add the iteminfo i have to add the bookinfo in case the item is book. but how can i figure out the itemid so i put it the bookinfo table?

i use SQL Server 2000 prof. edition and VB6...

Please help