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?