combobox relationships??

[vand_uk]

I have a relationship between 2 tables that links fields "universalID" to "model". What happens is when i select the universal ID it shows all the models in stock with that ID. But i want to do this on a form with a combo box. So I choose the UniversalID from my combobox and then a list is displayed in a different box under it to show all available models, can anyone help me do this, its probably really simple but i've been staring at it so long I've gone all dumb!!!

Thanks all
Tom

 

[KenHigg]

Would this be a situation where you could use cascading combo box type stuff?

Examples

kh