SOLVED
I got the answer from another forum I’m on.
For anyone else looking for this answer, you need to use ‘Lookups’ in Airtable.
In my case, I needed to link to:
- Sync Base 1 to Base 2
- Link ‘Unique Customer ID’ from Base 1 to the table in Base 2
- Add ‘Lookup Fields’ into the table on Base 2
- The Make scenario can now use the fields from the ‘Lookup Fields’ in Base 2 that are synced from Base 1