hi, good day for all , i having a problem , which is actually due with multiple insertion.

the scenario :
- i have a customer table, customerReferenceProduct table and product table

- customerReferenceProduct table have customerID and product_id, which actually use for keep track what are the product will show to customer

- let say, when user enter information for new product, all information will save into new product table, then this new product id will save into customerReferenceProduct table for all customer , so end up , we need to save all row that for each customer_id but with same product_id

below is my try sample
my problem is, when productid is user keyin data, but customerid is from customer table, how i include the productid for insertion ?

thank you very much for helping and guidance

What tools(s) are you using for your front end? A web page, a custom (n-Tier) application, or something different?

-PatP

i'm using web page in jsp

your "try sample" is not consistent with your explanation

your explanation is:
- user enter information for new product
- all information will save into new product table
- new product id will save into customerReferenceProduct table for all customer

the sql you need for this is --where does the 937 come from? that depends on which database you are using (which you did not mention)

if it's microsoft sql server or access, use @@IDENTITY, if it's mysql use LAST_INSERT_ID(), et cetera

hi, r937 , thks for reply , i'm using microdoft sql , do u mind to further explain on what is @@identity ? and also 937 ? thank you very much for helping

in summary, the productid is user enter data , which is dynamic and not from other table ..i still can get how the new productid insert into customerreferencetable ...

if the user is entering the productid, then you don't need @@identity

in my query, use the productid that the user entered instead of the number 937