I'm not 100% sure how to ask this question so searching the forums and goolge haven't been very helpful. Here is my situation:
I have a many-to-many relationship between Parts and Categories (a part may belong to many categories and a category may describe many parts). This is fine, and all works well.
What I am wanting to do is filter the parts based on whether they belong to all categories of a selected list (ie the user selects multiple categories and the program finds the parts that fit into every category).
I have been trying along the lines of:
Code:
from Part as part where (? in (select elements(AircraftModels) from part) and ? in (select elements(AircraftModels) from part) and......)
with each category in the list. Not only does it not work, it is incredibly ugly and I don't want to use it!! There must be a better way, however I cannot see anything in the manual that jumps out as being on the right track.
Any suggestions?