I am a beginner in Delphi and I have a Firebird database with 2 tables namely
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
Hope this will be considered a good question I have tried very hard to make a useful question.