This is actually a pretty simple project. I have created a field in our PRODUCTS table that is for admin use only. We input a bin number for the product to help stock pickers. The field in PRODUCTS table is updating with no problem.
I need to know how I can utlize that info and have that Bin Number appear on our invoices (I'd prefer it to be discreet, maybe prepending or appending to the model number).
I have created a new field in our ORDERS_PRODUCTS table to contain this information when a customer places an order.
In summary I just need to get that information to update to the appropriate field in the ORDERS_PRODUCTS table. Then the code to access it when printing the actual invoice.