Closing customer's bill

I need a way to close a billing cartel of a customer if he pays out all the amount he owes, by a command button in a form "Customer economics". The solution may be a negative record. But if I want to see all the paymetnts with a query, I will be able to. The purpose is every time I open the "Economics" form from the "Customers" one, it will appear on three bounded texts below,the rest of money he owes, the running payments,and the running charge. The billing cartel must contains "Date","Payment","Reason". You may work and change for my needs the [url removed, login to view] from Microsoft. I have a mdb to send you in which I work, but the language is Greek.

## Deliverables

Complete source code of all programming work done

Administração de Bancos de Dados Engenharia MySQL PHP Arquitetura de software Teste de Software SQL

ID do Projeto: #2824027

Sobre o projeto