Filter unique records in a field and populate into a new table

Question

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:

Song + Artist
Song
Artist

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:

Lists all unique artists from the Classic Rock Songs table into the Artists table
Links the records so that all songs for each artists show up in the Artists table

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:

Kamille_Parks11 · Accepted Answer

Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.

Jesse_L · Answer

Convert your existing Artist field into a Link To Another Record field, pointing at the Artists table.

Thank you! That is very obvious now that you have explained it, much appreciated :slightly_smiling_face:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded