Multiple Fields in a single Picklist?
I am creating a sample zoho database to experiment with related forms. Very simple app, but I'm running into a need for a two-field picklist, since the uniqueness is really a pair of fields.
The sample app is a playlist of songs, based on on-air date, artist, album, and song title. Since album and song titles are common across many artists, the uniqueness is the combination of three fields: artist--album--song title .
The issue is that I have these data (artists, albums) in separate forms, and I want to pick "songs" from a picklist that displays the artist-album combination. Artists and songs are in their own forms because I want to dynamically add artists as they are 'played'/added to playlists, so I can't pre-populate with a known/static list of artists or albums. And most of the albums are new releases, so I am constantly adding to the list [I am aware that adding to picklists' subtables on-the-fly will be added to zoho creator in the near future.]
Any ideas on how to achieve this? If I can pair fields in a lookup, I can probably reduce the number of forms needed.