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.