Is there a way to force a "re-look up" or "re-calculation" when changing information in one table that affects a calculation in another table.
I am using a standard CLIENT / INVENTORY / INVOICE / INVOICE LINE ITEM erd.
(with the line item table used to connect the invoice table to the inventory table).
My problem is when I change the price of a record in my INVENTORY table it is not updated in my LINE ITEMS table, unless I cut and and then re-paste the foreign key field inside the LINE ITEM table (the inventory fk inside of the line item table).
is there an elegant solution to this (or any solution at all ?)