Microsoft Access 2010 Help!?

In access 2010 I want to have two columns type and status, with the type being either manual or hydraulic and the status being open or closed if the manual type is chosen and either normal or overridden open if hydraulic is chosen. How do I create the query allowing only open and closed to be shown in the status column if i choose the type to be manual and vice versa for hydraulic? I think I have tried everything. I can do the lookup no problem refering back to the type and status table but its the query im having a problem with.