| Subject | how to use the same column from a single table to other tables? |
|---|---|
| Author | dice_in_trouble |
| Post date | 2013-05-02T04:03:11Z |
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.
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.