How to link subform using two fields

[rohnds]

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.

 

[SteveSchapel]

Rohnds,

Yes, there is no problem with having a subform linked to a main form on more than one field. You simply type the names of the fields in the subform's Link Master Fields and Link Child Fields properties, separated by a semi-colon, for example:
Make;Model

However, in this case you shouldn't need to. Linking only on the Model should do the trick. If you know the Model you automatically know the Make, right?