I have some values under "account" and I need to have the same values under "invoice", so, I'm trying to find a way to symlink my tables, so every time one gets updated, the another have the new value too. I'm developing under OpenERP, I can't trow that update directly on code, I need to write the rule using PgAdmin or something like.
I need to junction symlink 2 tables under Postgres.
ACCOUNT INVOICE
|ID|payment_type|@@@@@@|ID|account_payment_type|
|#1|cc |@@@@@@|#1|cc |
|#2|cash |@@@@@@|#2|cash |
|#3|cash |@@@@@@|#3|cash |