It sounds like you’re coming to Airtable from a professional relational database language like SQL, Microsoft Access, or FileMaker Pro (which is part of my consulting background as an expert database consultant). Now I provide expert Airtable consulting.
Airtable is a more basic database system, so it acts differently than other database languages on the market:
1. In Airtable, whenever you create a linked record field, you are linking to AN ENTIRE RECORD, not a specific column.
2. In Airtable, all linking must be done manually by you. There is no such thing as automatic linking of same values in Airtable.
3. Also, you do not need to create a unique ID for your first column… Airtable automatically creates a unique ID for each record for you.
Since you are brand new to Airtable, you may want to take my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning. Also, many Airtable consultants like myself are spending their time answering questions here.