I need to track deliveries from suppliers against purchase orders.
i.e I generate a purchase order on a supplier. The supplier may deliver:
* all products in one delivery
* products over a couple of deliveries
* may substitute product with an alternative
I am racking my brains on how to set the tables and the forms.
Can anyone suggest the correct structure for this? Perhaps know of a sample database to get my grey matter working?
Thanks
i.e I generate a purchase order on a supplier. The supplier may deliver:
* all products in one delivery
* products over a couple of deliveries
* may substitute product with an alternative
I am racking my brains on how to set the tables and the forms.
Can anyone suggest the correct structure for this? Perhaps know of a sample database to get my grey matter working?
Thanks