executor

Rlation problem

Discussion created by executor on May 17, 2018
Latest reply on May 30, 2018 by executor

I have 2 tables. Table A and Table B. Relation is field ID. Table B contain documentation and date of document creation of any product in Table A. Some documents contain information about changing the serial number of a product. This is noted in the CHANGE field. If there is no change, the field remains blank. When there is a change. I want the last date to be recorded in table A.

 

Pic1.png

Outcomes