Aeriu

But now i have another problem... I would like to search an artist or an album or a track. If i search a track i would like to see all the album that have that track and the related artists. I´m talking about a jazz catalog If i search for an especific album i would like to see it´s tracks and it´s artist. Or if i search for an artist i would like to see all his albums. Is it possible to have a layout to seach all this??? Thanks!!!

ok ok!!! I understod -) Thanks a lottttttt

Can you be more explicit please? I´m a beginner, sorry... what do you mean with "self relation"? I have a album table with albumID that is related to Tracks Table (Album ID). If i do a search for an album i see that perticular album, but only one track, to see another track i have to go to another record and the same with the other tracks that are related to that album.. I would like to have all the tracks records tha are related to that album. Maybe its not only a problem with the relation, i don´t know... Tahnks

Hello! I´m doing a Music (cd) Catalog and i would like to know how can i see the album tracks in a list. I would search for an album and then i would like to see the tracks that are related to that album... I have something like the previous post Dj catalog. Thanks

And If i want to make a search album to see all the songs that are in it?? Like in itunes. You select the album and then you ahve a list of the songs... How can i make that??? Thanks