How to update multiple records using one Airtable automation trigger

Hi! I’m trying to use Airtable Automations and running into difficulty when trying to update multiple records at once. I’m not entirely sure where the bug is coming from. Here’s what I’m trying to do…
Table A contains several records for unique items that I’ve sold.
Table B generates invoices pulling multiple records from Table A.
When appropriate, I’d like to click a checkbox field on Table B that says “Client Paid Invoice,” which will then update all the unique records in Table A that have been paid for.
Is there a way to do this?

Thank you so much for your time and thoughts! You make my day.

Cameron