OK I am totally confused. This seems to really be a simple process but I cannot figure out where the ORDER_PRODUCTS TABLE is being populated from... Like stated above I created a new FIELD called PRODUCTS_DESCRIPTION in the ORDER_PRODUCTS TABLE. We need to populate it at the same time that the PRODUCT_ID, PRODUCT_MODEL, ect; ect; is being populated into the ORDER_PRODUCTS TABLE during either when the customer ADDS a product or in the CHECK-OUT phase. I do not know when nor where this population is being activated. Once this new field is populated from PRODUCTS_DESCRIPTION/PRODUCTS_DESCRIPTION<-----this is the TEXT ONLY fieldno images,ect;....we can call this new field into INVOICES/PACKING SLIPS/EMAILS very easily!

PLEASE PLEASE can anyone define where the code is that does this transfer of fields and present some lines of code to add to the new field? Judging by the number of views on this topic there are a lot of Zenners out there looking for answers on this. Thank you for any help on this