Deleted Links not reflected in system field for links

I have a Authors table linked to a Books table. At one time I had 4 books linked to an author. Then I deleted one of the books. The NocoDB UI for the Author only shows 3 linked books. But the system field that contains an array for those links continues to show a link to the deleted book.

I’m using that system field to create a report in n8n. Is there a way to make sure it’s updated with deletions?