Huge Query Headache

[Gary]

I have two tables:



Equipment and faults

the equipment table has a field component groups. There are a series of faults common to each component group.

Basically I have a many to many relationship.

What I want is for the faults group to basically have a set of check boxes for each component group it applies to. Then whenever I have a combo box in one form that allows the user to select component groups a second combo will only display the faults associated with that group.

I hope that I have made this clear... and I hope that someone can help...

Gary

[Gary]

This worked! added a me.requery in and everything was perfect

SELECT Faults.Fault
FROM Faults, Equipment
WHERE ((([forms]![form1]![eqName])="Group1") AND ((Faults.Group1)=Yes)) OR ((([forms]![form1]![eqName])="Group2") AND ((Faults.Group2)=Yes)) OR ((([forms]![form1]![eqName])="Group3") AND ((Faults.Group3)=Yes))
ORDER BY Faults.Fault;