Amend Linked List

When updating the status (paid/unpaid) of any record in the first list, I need to update the records in the second linked list to show only items sorted as (paid/unpaid) in the first linked list.

When I tried to create an automation to "amend record", the list adds the new invoices classed as (Unpaid) for instance but it does not delete the other items which was classed as (Paid). This creates a difficulty to update the client statement of account.