HOW TO GENERATE PRODUCTION ORDER AS PER SALES ORDER NUMBER OF LINES

[Kamayo Ako]

Have a good day to all

I have to Tables
- Sale Order Table
- Production Order Table

What is the best way to generate production order as per Sales Order line. As per image below shows we have 3 lines in Sales Order, when i click generate it will add to the Production Order Table.

thank you for continuing support

God Bless you All

Kamayo Ako

 

[arnelgp]

Don't you think you need Sales Order Number for reference of which SO is being
produced for a particular production order.

You can also use 1 Production Order for each corresponding SO and make the traceability simple.

 

[Pat Hartman]

The code behind the Generate button should use DAO and .AddNew to add the production order record. Then using the new ProductionOrderID, the code should run an append query that copies the order details using the SalesOrderID as criteria and appends to the ProductionOrderDetails table using the new ProductionOrderID as the FK.

 

[Kamayo Ako]

The code behind the Generate button should use DAO and .AddNew to add the production order record. Then using the new ProductionOrderID, the code should run an append query that copies the order details using the SalesOrderID as criteria and appends to the ProductionOrderDetails table using the new ProductionOrderID as the FK.

I will do that sir. Thank you so much.