This is probably a basic task but I’m not finding info on how to do this.

In Table A I have application info from applicants that are submitting through a form

In Table B I have info coming in from Paypal (via Zapier) of payments from applicants (their application fee)

How do I have each record in Table A reference each record in Table B, matching the records by the Email column, so that Table A automatically brings in the $ amount in Table B?

Thanks for any tips!