Hello! I searched for this, but I could only find similar results – but not the result I need.
I have a Purchase Order table and a PO_ITEMS table where I create one line for each item I’m buying. I need to control serial numbers of these items, so each record is later linked to a sale.
What I need is to create the PO, add the PO_ITEMS and in the end, have a pretty Purchase Order (Page Designer form) with the total quantity I need for each model. This is the form which will be sent to the manufacturer.
The examples I found show the Purchase Order with every line from the PO_ITEMS table, not a summarized table.
Can anyone help me? I’m attaching an image to help understanding.