Forum Discussion
StephenStephen
7 years agoQrew Assistant Captain
When order line is added, then add a record to the parent table.
Values: Copy the value from "Order Number MOS" which is a formula field that holds the order number to "Master Order Number" which is the Key Field of the parent table. In my test data, I through error 51. because I had two lines that had the same order number (because an order can have multiple lines). I was hoping it would just overwrite the new record...but I think Add has to be unique.?
Values: Copy the value from "Order Number MOS" which is a formula field that holds the order number to "Master Order Number" which is the Key Field of the parent table. In my test data, I through error 51. because I had two lines that had the same order number (because an order can have multiple lines). I was hoping it would just overwrite the new record...but I think Add has to be unique.?