I have.... the only thing is that i am not sure if it is necessary to do so.
The only to items that i currently have with many2many relationships are Category and Producer.
The table carries videos and DVDs that my company carries.
I would like to track items by sports > > but some fit into multiple categories and some into multiple sports.
Do you think that the best solution is the way that i have it set up on the attached picture. If so, i cannot combine all of this into a single query correct >>> is the only way to go about it is through sub-forms?