Purchasing & Booking in Deliveries Design

[Will]

I am designing a purchasing database & have a problem with delivery charges
where an order is delivered part shipped. The three tables that are
concered are tblPurchaseOrder, tblGoodsIn and tblGoodsInInvoice. My
tblPurchaseOrder has a field for delivery cost as one purchase order has one
delivery cost. I have been told that the company sometimes when raising
large orders have staggered delivery and are invoiced for each delivery. My
problem is, is that when it comes to matching supplier invoices, where there
is more than one delivery for a single purchase order, the delivery charge
shows for each delivery when it actually is an overall delivery charge. Can
anyone recommend a solution?

Thanks in advance

 

[Lynn Trapp]

You need to handle that with the details of the Purchase Order. May I assume
that you have a PurchaseOrderLines table? If not, you need on, that is
related many to one to the tblPurchaseOrder. Then, for the multiple
shipments and invoices, you would need a third table that you could call
PurchaseOrderLineShipments, related many to one to PurchaseOrderLines.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html