[firebird-support] how to build a relationship between 2 tables in firebird?

dice_in_trouble Sun, 21 Apr 2013 03:32:25 -0700

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:

&#9556;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9559;
&#9553; name &#9553; date &#9553; balance &#9553; status &#9553;
&#9562;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9565;
My daily collection contains the following columns:

&#9556;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9574;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9559;
&#9553; date &#9553; name &#9553; payment &#9553; balance &#9553;
&#9562;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9577;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9565;
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.

Hope this will be considered a good question I have tried very hard to make a 
useful question.

firebird

[firebird-support] how to build a relationship between 2 tables in firebird?

Reply via email to