| Subject | how to build a relationship between 2 tables in firebird? |
|---|---|
| Author | dice_in_trouble |
| Post date | 2013-04-21T10:34:22Z |
I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database.
My masterlist contains the following columns:
name
date
balance
status
My daily collection contains the following columns:
date
name
payment
balance
I would like to build a relation in which the balance from masterlist will be copied to the balance column of the daily collection, and when I update the column in the daily collection it will also update the content of the masterlist.
My masterlist contains the following columns:
name
date
balance
status
My daily collection contains the following columns:
date
name
payment
balance
I would like to build a relation in which the balance from masterlist will be copied to the balance column of the daily collection, and when I update the column in the daily collection it will also update the content of the masterlist.