Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 08, 2020
I have a brand new base with some data that I imported in a CSV. It created a table called Classic Rock Songs (which is as awesome as it sounds) and populated records into 3 fields:
Each artist can have multiple songs (or at least the ones that were’t one-hit-wonders!), and I want to create a second table that:
I’m basically struggling with the first step above, and how to create a new table with unique artists.
Appreciate any ideas… rock on! :guitar:
Go to Solution.
Dec 09, 2020
Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.
See Solution in Thread
Dec 10, 2020
Thank you! That is very obvious now that you have explained it, much appreciated :slightly_smiling_face: