Hello
I have been creating a database to help manage call off products from suppliers and until now I have built a structure that works, as far as the flow of data is concerned. I am able to enter all the data directly in the tables cascading down from entering a PO with a Supplier to Calling Off product and then entering details of the product shipped. However when I tried to create a shipping order to the Supplier I was missing a Shipment table and I am struggling to decide how to link this in currently it is linked to the Supplier table but there isn't a direct relationship to the call off items. I have attached the relationship diagram. The point of the exercise is to be able to call of fruit and manage the shipping details and provide the storage suppliers with the information required before delivery and for me to be able to look up what orders are placed / shipped / delivered etc. Would appreciate some advise on the structure of the data, I am starting to think that I have approached this from the wrong angle.
I will of course answer any questions regarding the flow but the tables should have the correct data but maybe I have should link it together differently.
I have been creating a database to help manage call off products from suppliers and until now I have built a structure that works, as far as the flow of data is concerned. I am able to enter all the data directly in the tables cascading down from entering a PO with a Supplier to Calling Off product and then entering details of the product shipped. However when I tried to create a shipping order to the Supplier I was missing a Shipment table and I am struggling to decide how to link this in currently it is linked to the Supplier table but there isn't a direct relationship to the call off items. I have attached the relationship diagram. The point of the exercise is to be able to call of fruit and manage the shipping details and provide the storage suppliers with the information required before delivery and for me to be able to look up what orders are placed / shipped / delivered etc. Would appreciate some advise on the structure of the data, I am starting to think that I have approached this from the wrong angle.
I will of course answer any questions regarding the flow but the tables should have the correct data but maybe I have should link it together differently.