I recommend you to read the introduction: https://guide.airtable.com/introduction-to-databases/
“Records – Records are the database equivalent of a row in a spreadsheet. Each record is basically an item in your list. In a table of books, each record is a different book” https://diigo.com/0cdqng
Making sure of something here. If I have a table of people’s names and then another table of locations, and I link them. Lets say I have 50 people’s names and 50 states they could possibly live in. That means my base will have 100 records total, regardless if I link people to all the states?
But, if I have two columns in one base, name and location, and put in each location, then I will only have one table with 50 total rows, so just 50 records?
It seems as though linking is unduly penalized in this way. Am I misunderstood?