I can’t seem to figure this out. Here is what I’m trying to accomplish. When A Record Matches a Conditon In Table 1, then Update Record in Table 1 (Field 1) with data from Table 2 (Field 1). Is this possible using the automations?
Esssentially what is happening is when a drop down box in Table 1 = “Policy 1” then get the corresponding Policy from Table 2.
To clarify, I meant: Why are you using a Single Select field instead of a Link Record field?
They don’t have to work together, you likely only need one.
The point of using Linked Records in instances like these is they are designed to work with Lookups (or Rollups), whose sole purpose is to pull in data from another table. Single Selects are not designed to do this. While you can set something up with Automations, you would be using the wrong tools for a (likely) simple job.