I have two table, I containing make and model of cars and a few others.
I have another table containing all the feature of the car linked via "Stock Number"
I have a form and subform linked using the field "model". But I have designed the main such that I can filter the sub form using "Model" and "Make" of the car. This is done by first having drop down combo for "Make". When the user select the "Make" of the car, it will populate the another drop down combo listing "Model" for only car that match the "Make". I have accomplished this by using the sql statement for the record source of the combo box.
My question is, Instead of doing this way, can I linked the form and the subform using a sql with two or more fields.