Can a script loop through every table in a base?

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!

Yes, a script has access to all the records in all the tables in the base. As long as you know how to identify the records that you want to link and the linked record fields already exist, a script can do the linking.