Good Day;



I am new Access and need assistance.
I have created two tables a CAR table and Payment Schedule table, which are linked by Registration number. In the CARs table there is an Amount_Outstanding field. In the Payment Schedule table there are, amoung other field, the Payment_Due_Date and Balance_Remaining fields. The Amount_Outstanding field in the CARS table should be the Balance_Remaining value on the Maximum Payment_Due_Data where the Maximum Payment_Due_Date <=Today().

The issue is I cannot get that data to be populated in the CARs table. Any help?