O
Outlander_30
I want to create a simple database to store Supplier Names, Pallet Form #'s,
Pallets Received, Pallets Shipped, and Date. The Pallet Form # will never be
the same but the Supplier can be. I've created a form that someone can use
to enter the Pallet Form #, the Pallets Received, and the Pallets Shipped
daily. The key is that I need to enter new pallet form numbers and the
number of pallets in and out and I need this added to the totals for the
previous entries for specific suppliers. How can I go about this so the
Supplier doesn't get repeated but the Pallet Form # and the Pallets In/Out
do. Then I need to keep a running total of the Pallets In/Out so I can
determine if we owe a supplier or if the supplier owes us. Hope this makes
sense.
Pallets Received, Pallets Shipped, and Date. The Pallet Form # will never be
the same but the Supplier can be. I've created a form that someone can use
to enter the Pallet Form #, the Pallets Received, and the Pallets Shipped
daily. The key is that I need to enter new pallet form numbers and the
number of pallets in and out and I need this added to the totals for the
previous entries for specific suppliers. How can I go about this so the
Supplier doesn't get repeated but the Pallet Form # and the Pallets In/Out
do. Then I need to keep a running total of the Pallets In/Out so I can
determine if we owe a supplier or if the supplier owes us. Hope this makes
sense.