This is my problem. I have created 2 tables, one parent (PO) and one Child (Products) what I am trying to do is add multiple record to the child table. This is how far I have got.

I have created a insert form which allows me to create a Purchase Order, on submit, I have it displaying that page I then click on a add items buttom which takes me to a form which is the products page. Once I have entered the qty, product and price I hit the submit button and it goes wrong. Say unable to add record. All I want to do it add a number of products relating to a single purchase order. Im sure my answer is in stored procedures, but I am a newbie at this so could do with some direct. Cheers

derran