Filter by maker and model

[Avick]

I am trying to build a table that lists aircraft viewed by plane spotters.

In the “aircraft_spotted” table I have two look up wizards. The first lists the make of aircraft and the second lists the type.

What I am trying to do is filter the models down to the maker.
If I select Boeing I will only get Boeing models and nothing else. The same would apply to Airbus and so on.

I would like to keep this information contained within the table without using a query but if I have to use the query for the model lookup then so be it.

This one is driving me nuts.

 

[The_Doc_Man]

You might try searching this forum for topic "Cascading Combo Boxes" to see how this could be done with combo boxes. Even if you didn't want to use combo boxes, you might get some ideas about how to make sub-query A affect the return set for sub-query B.