I have 2 tables, namely clients and collection. I have on the client table the columns named client,date,balance and address respectively.
The daily collection has a column named time stamp and payment. But it also need to have the list of client and balances from the clients table and I want the client table to be updated if I edit the collection, same goes to the collection table, I want it to be updated when I enter data on the client table. The columns that I need to have a relation are the client and balance columns but I have no idea on how to do it. Caon somebody please guide me on this. Thank you very much.
