Need help storing/accessing multiple records under one ID

[Guest]

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.

 

[Martin Walke]

I would have thought the easiest way would be to have 2 tables. One that
contains your suppliers details, including the running total, and the other
with the order details (fairly standard suppliers tables) and then link the
2 using the suppliers ID

HTH
Martin