Temp Table with Two Outcomes
I have a temp table of skus that require ordering which has been generated from our sales records.
In this table, are the [Supplier Code], [SKU] and [Quantity].
I have a purchase order set-up, that consists of two tables, the header which stores the [Supplier Code], and the detail that stores the [SKU] and [QUANTITY].
Is it possible to use the information in the temp table to send the right information to the right table (header and detail)?
"To come second, means you're the first to come last"