Hi,
I was trying to make a list of songs and performers using cck and views. I came really close, thanks to some kind help on this forum, but i came to a bit of a dead end when I discovered that node reference fields could not be sorted. - I could list the song titles, but not the performers as they were in the list from a node reference field.
I have now done what I would like by making a separate mysql database with 3 tables: titleID and titles,performerID and performers, and a table to link the two.
I can display the database in drupal with a custom php page with an sql query.
My questions are:
1. did I give up on CCK and views too early ? is it possible to make simple relational database functionality with these two - or some other way
2. Should I be wary about having an 'extra' database in drupal like this.
and
3. are there any ways I can make to populate the database rather than making my own web form with HTML and php ?
Thanks for any help.
