I want new and modified records in Table 1 to automatically be added to Table 2.
Is that possible and if it is, how to do it?
Automatically adding new and modified records from one table to another
If you want it to occur automatically, then you’ll need a 3rd party tool, such as those found in the integrations list or something custom via the API.
Manually, however, you could use advanced linking (linked record & lookup fields).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.