With a header-and-detail structure, how do I populate a header from the first detail?

Given a header-and-line-item structure, in MySQL (in this case, a quote header and its details), we have a field at the detail level, "Vendor," and we are adding a new field at the header level, call it "PrimaryVendor."

Going forward, the application will pull use the value of "PrimaryVendor" as a default for the detail-level "Vendor."

But for the existing database (thousands of records, an average of around four details per quote), we need to put something in the new field, and the...

With a header-and-detail structure, how do I populate a header from the first detail?

from MySQL https://ift.tt/2UMbaJZ
via IFTTT