Multiple filters in Many-to-Many relationships

 Hey guys,

 I am having tough time using NetTiers on the front end of a website. The CMS works perfectly fine.

Problem

I have a table - 'Music' and two more tables: 'MusicCategory' and 'MusicInstrument'.

Multiple instances of 'MusicCategory' and 'MusicInstrument' can exist for 'Music' (Music can be found under more than one category and have more than one instrument).

I have built a custom control for the filtering with 2 databound EntityDropDownList controls. However, now I want to be able to perform filtering on the 'Music' table with the values selected in the EntityDropDownLists.

Furthermore, other search filters will be added in the near future, on fields found in the 'Music' table, such as 'length' or 'title'. 

I have tried using MusicCategoryFilters and MusicInstrumentFilters but with no success so far.

I have included the SQL script required to create the 3 tables in question.

If anyone can advise me as to what the best way to go about it would be, I will be very grateful and it will help me make progress in the project.

Thanks in advance :)
 

Bump! 

I think that a custom stored procedure is probably your best bet right now.  This will allow you to pass in whatever parameters you want.  Unfortunately, we don't currently have a good solution for this type of scenario (that I know of).  If you have ideas of how this could/should work, let us know.