Topic: Retrieve tracks of a Musical CD
Hello to all
I'm working on a music cd collection manager.
I use several tables, one of which stores the tracks and their duration (so as not to overload the main table (with artist, name of the album, musical style, etc.).
When I consult any artist, I would like to list the tracks belonging to this or that album of this artist. (Behin OnCellClick from the main Tablegrid)
What is the correct SQL syntax to achieve this?
Is it a good idea to save the tracks (and their duration) in a dedicated table having a relationship with the main table?
Thank you for your leads and your ideas on this topic
Best regards
JB