Can a script link a record in TABLE A to the matching records (via email addresses) in multiple tables TABLE B, TABLE C, TABLE D, etc in one go or does each one have to be its own scripting app? Thanks!

Hi! I am using an automation to run a script when a record is created in SIGNUP table. The script should link the records (which are people) between two tables—SIGNUP and CUSTOMERS. The primary field in both tables is the person’s name but it is easi...