I have three 3 tables company, payment and import table.
The import table consist of the following fields ImporterID, Vessel, Date(vessel arrival date),Item(there ore only 4 items) and the Amount owed for each item.
I have the payment table which have the following fields PaymentID.ImporterID, Importer Name,Amount Owed,Amount paid, date paid, receipt no. and Balance
Do I need the amount Due in both tables, Because I need to know how much the companies owe every month(this database is meant monitor imports of three items and the payment of the tax