Use data from one row on another?

[Haahz]

Hi, I'm very new to access and I'm building a system on Access for a company. The system is a booking and stock control system, and I've become stuck. I have made all the tables, one row on the table is really bugging me, I've put Car Make as one row for example Citroen, Fiat, Ford etc, I want it so when you select one make for example I select Ford, the Car Model row lists all Ford makes for example Escort, Mondeo etc. I've done the Car Make row but cannot for the life of me do the Car Model row. So if any of you have any solutions I'd be very grateful if you shared.



Sorry if this is in the wrong section by the way.

Haahz.

[ibgreat]

What you want is a cascading combobox. See this three part tutorial for setting them up....

http://datapigtechnologies.com/flash...combobox1.html
http://datapigtechnologies.com/flash...combobox2.html
http://datapigtechnologies.com/flash...combobox3.html