Temp Table with Two Outcomes (1 Viewer)

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)?

in your append query, use the BUILDER to pick the item on the form to add to the table.
usu:
forms!myForm!txtSuppCode

Thank you for your answer, I'm not sure how that works. Are you saying I need to create a query/form with all the data from the temp table, then use the builder to take out the supplier code and put it in the header table, then put the remaining two fields into the detail table?

Could you possibly expand your reply to show me how it works?

-----

Field A = Supplier_ID - this needs to goto table_purchaseorderheader

Field B = SKU_ID
Field C = QTY - these both to table_purchaseorderdetail