I have a table called Operations_Master_Check which records [Product Type] and [Description] among others. I have another table called Product_Master_File which feeds those 2 columns in Operation_Master_Check. The product itself is a wood pole that goes through various stages. There are times a pole will be altered for quality reasons and what I have presented to the user is a serious of questions if they flag the pole as reject, the last options being [New Product Type] and [New Poduct Description] which are drop downs fed from the Product_Master_File.
What I want to do after the user selects the new type and description and saves the form is to trigger an action to update the Product_Master_File with the new values so the next time the pole is scanned it presents the user with the new data.
Based on the table and columns above could anyone help with an expression for that action?