Subject how to use the same column from a single table to other tables?
Author dice_in_trouble
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.