Hello. I have data that is in 2 separate sheets on my Airtable and the common reference is the vendor ID.
I want to link the column Vendor ID on the Data Page to get information available on the Cost Center Information page when I click on the Vendor ID in the Data Page.
On the Cost Center Information page there are multiple cost centers for a single vendor ID in many cases.
I tried to link the Vendor ID column to Cost Center Information page but it is only picking up the first line having a cost center.
Can I get some help on how I can do this?