Solved Change quote into an order

[slharman1]

Are you saying it's working? or have you got a problem?

If a problem, then you can do some tests yourself.

Set up a temporary table with data in it, sample data that you can pass through using the insert into query. You'll only need 5 or 10 records. Keep changing the contents of the records until you get it working, and then add characters back in until it breaks. You should be able to identify what is causing the problem.

It is working for the parent table but not for the child tables.
I am not sure my nested loops are correct.

 

[arnelgp]

have not tested yet.

 

[slharman1]

have not tested

have not tested yet.

I have actually solved the problem of getting the INSERT INTO not working.
Could you look at my new code and tell me where I am going wrong with the looping for this line: Do Until rsOrderDetailsList.EOF
I am getting data from another record in the child table.
I will take a look at your code and try to figure out what you are trying to show me.
Thank you