There is no table shown named "PO".
Am I correct that a record in Orders is a PO (Purchase Order? normally, if you are selling goods, its an invoice if you are purchasing goods, it's a purchase order.)
What is the purpose served by a record in Delivery Note? (Knowing the intended function can help analyze how to set up relationships and layouts.) Does one record in Delivery Note represent one shipment (Delivery) of ordered goods to the customer?
If an order = a PO, then it would appear that you need to link Delivery Note to orders, not line items and with the primary and foreign key match ups reversed to make it one Delivery Note to many records in Orders:
Delivery Note::DeliveryNoteID = Orders::DeliveryNoteID
That enables multiple records in orders to link to a single record in orders.
same case to invoice layout, i want to include several desired delivery note, with several POs and their specific details
And this is the same issue. your relationship is set up for many invoices to one delivery note. If you want the opposite relationship, you need to reverse the primary to foreign key matchups:
Invoices::InvoiceID = DeliveryNote::InvoiceID
thanks for your reply on this. it's about the consignment we've currently doing with the consignment shop.
we have customers place orders (or purchase order from customers to be exact) to the consignment shop. once we receive the orders, we proceed and arrange shipment to consignment shop when finished. we would send consignment shop and customers one delivery note each shipment made. format as attached photo.
after shipment, we would issue invoice to consignment shop twice a week, including different delivery note with the line items showing what had been shipped, to ask for payment from consignment shop.
this is the workflow we're currently doing and your assistance on this would be appreciate
I take it then that each PO is a record in orders and each delivery note documents a shipment of possibly multiple orders. That was my assumptions in my previous post so my comments about the relationship changes you need to make would then all apply correctly to your situation.
thanks for your reply!!! we would work on this and revert to you if we can do this!! so kind of you!