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.

 

[boblarson]

1. You want "Cascading Combo boxes"

2. You can't do that in a table, you need to do it on a form.

3. Here's a sample with a cascading combo box:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip

 

[Chrism2]

IMHO your Manufacturers and Models should be on separate, related tables. Just as should be your stock.

Not sure if this is the case from what you've said, but if it's not; I'd look at that.