Can't edit the OrderDetails db table

I must've spent over 8 hrs. trying to figure this out. No matter what I do I can't get the column in the orderdetails table (created by the wizard) named DetailProductID to populate from a different source. My shopping cart is db driven and it's automatically picking up the ID field from the source db. I tried changing it to pick up from another column called MessageNumber but I can't get it to work. I just get an empty field. So I added a new column named MessageNumber (same as the source), and I want to populate it with the MessageNumber.

Is there a step by step process in adding a new field to the 'orderdetails' table and getting it to populate?

Or is there a way to get the DetailProductID to pick up from a difference source column?

Either of these would work for me. I just want to get the 'MessageNumber' in there.

Thank you.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

I'm a bit confused on the support ticket. The subject line says:

Subject: Does the checkout_success.php page still has session values?

It should be:

Subject: Can't edit the OrderDetails db table

??

I started the one ticket for both this problem and the other you where reporting
I will call next week to look into this issue with you.

Ok, thanks. The other issue is resolved.