complex query? how to ONLY display the set of data

[~ angel ~ via AccessMonster.com]

Am having issues and will try this post in this format and see if anyone can
help.

ok, this is all the possible codes for AE185.
AND depending on the Options selected for AE185 on invoices, the Codes will
differ.
The ComboID is the differentiator.

Guitar Option Code ComboID
AE185 185RR 1
AE185 186RHT 1
AE185 187RT 1
AE185 38 185RR 2
AE185 38 186RHT 2
AE185 38 187RT38 2
AE185 BB 185RR 3
AE185 BB 186RHT 3
AE185 BB 188RT-B 3
AE185 38 185RR 4
AE185 BB 185RR 4
AE185 38 186RHT 4
AE185 BB 186RHT 4
AE185 38 188RT38B 4
AE185 BB 188RT38B 4



so for the Code that repeats in the ComboID is only because the Option(s)
also requires that Code as well as the other Codes.

for instance, if the invoice ONLY has Option 38 from the Options defined for
Codes, then the result would be:
Code:


AE185 38 185RR 2
AE185 38 186RHT 2
AE185 38 187RT38 2

AE185 BB 185RR 3
AE185 BB 186RHT 3
AE185 BB 188RT-B 3

AE185 38 185RR 4
AE185 BB 185RR 4
AE185 38 186RHT 4
AE185 BB 186RHT 4
AE185 38 188RT38B 4
AE185 BB 188RT38B 4



Code:


Invoice Guitar Codes
123456 AE185 185RR 186RHT 187RT38 <-- say this
invoice had Option 38 that was the only match
234567 AE185 185RR 186RHT 188RT-B <-- because BB
was the only one that matches
345678 AE185 185RR 186RHT 188RT38B <-- because both
38 & BB matches



So guess the question is how do I write a query or function (VBA) to be used
in a query to get the results for ONLY the matching options so the correct
codes for just these options are displaying?

It's difficult to me in figuring that out. how to make sure that the result
does not show the ALL the codes that match but ONLY the codes in the
combinations. Again, hence the reason why I got to the point of having
Combination IDs to differentiate that.

hope I made sense here. Not sure how else to ask the question other then to
try and provide examples :-(
let me know how else to explain if this is not helping.