I think i did it right.
SO my main goal, is that the "distributor" field on the table "products" needs to reflect exactly what manufacturer is. which i know is redundant but is required for the setup that the website builder has. I know that i can just create a field on the "Products_form" and manually input it or do another drop down. BUT just for automated purposes i'm trying to just get it to either auto copy there, or for a field in the form to auto populate what the manufacturer is and save it to distributor field IF POSSIBLE. If its not possible/easy enough to figure out, no big deal. Thanks for everyone who attempts to help! Its greatly appreciated
Attachment 46090