Hi all, excuse my bad english.
I have a table BOOKS, a table INVOICE and of course a table DETAILS_INVOICE (and other tables...)
In table DETAILS the field PRICE is a looked-up value (in auto enter tab) from table BOOKS. Everything works fine, but...
Problem is that when the INVOICE is made, when I update de PRICE in PRODUCT table, and I come back in INVOICE, the PRICE value in DETAILS_INVOICE does not update. How to resolve this problem?
Thanks in advance.