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.