I'm trying to find the best workaround for the fact that we can't select multiple "references" in a database field.
In my real-life example, I have a database of songs and am using the Genre field to ALSO contain Themes. So a Genre field might look like:
The genre is Country, and the song has themes Color Song and Day Band (there's a color in the song title and a day of the week in the band name)
You can find the existing songs list here: https://www.seanarenas.com/songs
I could make a database called Themes and add Country, ClrSng, and DayBnd to it, but there's no way to select all of those as references.
My purpose is for a user to be able to select a theme, and see all songs that fit that theme. If they click DayBnd, they should see a list like this
And if they click Kissing Songs they should see a list like this:
But I took these screenshots from my Virtual DJ software, not from the Web site. All of these songs are in the database on the Wix site. I just don't know a way to set it up to achieve my goals here; any advice?