Make changes to a list of things - 2 tables

[alvin.david]

Hi.
I need help.

Based on the quotation ID, I am trying to update a column (Invoice Link) in my invoice table.
I have another table called PDF documents, and there are 2 columns.
Quotation ID and PDF link.

Based on the Quotation ID in the invoice table and PDF documents table, I need it to pick up the PDF link in the PDF documents table and put it back at the invoice table based on their respective quotation IDs

I tried doing this but I failed.

Just to add on that my invoice table Invoice link has some blank cells and some cells have values in them.

Any help is greatly appreciated.
Thanks.
Alvin.

[georgecollier]

:first item instead of :each item.

Each item would return a list, but Invoice Link should just be one text (as surely there is only one Invoice Link per Invoice)