Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 08, 2020 04:57 PM
Hey all!
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:
Solved! Go to Solution.
Dec 09, 2020 05:31 PM
Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.
Dec 09, 2020 05:31 PM
Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.
Dec 10, 2020 07:18 AM
Thank you! That is very obvious now that you have explained it, much appreciated :slightly_smiling_face: