AnsweredAssumed Answered

UPDATE PRICE on detail_table INVOICE

Question asked by Lub on Feb 25, 2016
Latest reply on Feb 25, 2016 by Lub

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.

angelo

Screenshot 2016-02-25 23.21.45.png

Screenshot 2016-02-25 23.12.24.png

Outcomes