thanks,

now what if i have foreign key with the table.

exalple

product

product id identity(1,1) primary key,

name varchar(50))

item

itemid identity(1,1) primarykey,

itemname varchar(5))

productitem

(productid datatype reference product(productid),

itemid datatype referenc item(itemid))

how can i insert value in productitem from multicast.

if both are identity column, they will insert automatically