I am building a database to track and balance incoming and outgoing orders of crops.
I have 3 tables right now.
"Products" is a list of products in the database
"Incoming_Orders" is a list of incoming orders with the following fields;
"Order#", "Supplier", "Order_Date", "Ship_Date"
"Incoming_Order_Information" contains the details of each order with the following fields;
"Order#" (linked to "Order#" in "Incoming_Orders"), "Crop_Description" (Linked to "Crop_Description", the only field in the "Products" Table) and "Quantity_Ordered")
One crop may be ordered multiple times on different orders and from different suppliers, I want to see the total amount ordered for each crop across all orders.
I think the next step is to use a query that will consolidate the orders to show the quantities ordered for each crop, however I am not sure how to achieve this or if it's even the correct way to go about it.
Thanks.
I have 3 tables right now.
"Products" is a list of products in the database
"Incoming_Orders" is a list of incoming orders with the following fields;
"Order#", "Supplier", "Order_Date", "Ship_Date"
"Incoming_Order_Information" contains the details of each order with the following fields;
"Order#" (linked to "Order#" in "Incoming_Orders"), "Crop_Description" (Linked to "Crop_Description", the only field in the "Products" Table) and "Quantity_Ordered")
One crop may be ordered multiple times on different orders and from different suppliers, I want to see the total amount ordered for each crop across all orders.
I think the next step is to use a query that will consolidate the orders to show the quantities ordered for each crop, however I am not sure how to achieve this or if it's even the correct way to go about it.
Thanks.